Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: KSH SCript
crsoza_at_hotmail.com (C. R. Soza) wrote in news:c18ea449.0109190555.1c455685
@posting.google.com:
> sqlplus username/password<<-EOF
> select * from table;
> EOF
>
> that's it.
>
It is slightly better to do
$ sqlplus <<EOF
username/password
select * from global_name;
EOF
exit
because in the top response anyone can do a ps -ef and will see the username/password values!
HAND! Received on Wed Sep 19 2001 - 19:47:11 CDT