Re: Getting values into SQLPLUS from Unix

<amerar_at_iwc.net> ha scritto nel messaggio news:1134662664.740210.169590_at_o13g2000cwo.googlegroups.com...
> Using the shell variables, how do I get SQLPLUS to recognize them?

SCHEMA="SCOTT"
MV="MV_1"
sqlplus /nolog <<EOF

   connect / as sysdba
   ALTER SESSION SET CURRENT_SCHEMA=${SCHEMA};    exec dbms_snapshot.refresh(UPPER('${SCHEMA}'.'${MV}'));    exit
EOF

-- 


Regards,
Dimitre Radoulov