| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting values into SQLPLUS from Unix
You don't need to. Unix will replace the variables when you run the
script.
e.g.
Say you call the script with parameters X and Y, what will be passed to SQL*Plus is:
sqlplus /nolog << EOF
connect / as sysdba
ALTER SESSION SET CURRENT_SCHEMA=$1; /* semicolon here! */
exec dbms_snapshot.refresh(UPPER('X.Y'));
exit
EOF
HTH
--j
Received on Thu Dec 15 2005 - 10:12:15 CST
 |
 |