how to save environment variable in linux code example

Example 1: set permanant environemt variable

$EDITOR ~/.profile
#add lines at the bottom of the file:  
     export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
     export ORACLE_HOME=/usr/lib/oracle/11.2/client64

Example 2: linux set environment variable

# Linux - Bash 

# syntax 
# export *=*;

# example 
export ORACLE_SID='sales_database';