how set environment variable before command line linux code example

Example 1: shell set environment variable

export VARNAME="my value"      # shorter, less portable version

Example 2: linux set environment variable

# Linux - Bash 

# syntax 
# export *=*;

# example 
export ORACLE_SID='sales_database';