Re: ksh scrip to include various sql commands and rownum

Bilal wrote:

> sqlplus - silent "$USERNAME/$PASSWORD@$DATASTORE" <<EOF

This is a little bit safer, since you can restrict who can read your script but everyone can see your command line with the ps command:

sqlplus -s /nolog <<EOF
connect $USERNAME/$PASSWORD@$DATASTORE
...
EOF

-- 
Kevin Rodgers