Re: SQL Batch File

"Gaser Nadeem" <gsrnadeem_at_mrcc.aast.edu> wrote in message news:<VK0T9.257659$F2h1.22103_at_news01.bloor.is.net.cable.rogers.com>...
> I want to make a batch file in linux to run SQLPLUS.exe and give it the user
> name and password and a SQL Command to be run in it.
> i.e.
> SQLPLUS.exe Scott/tiger Select sysdate from dual;
>
> so how can I write this batch file.
>
> thanks

Something like this:

sqlplus -s username/passwd << EOF
sqlplus commands
and/or sql statements
EOF Everything between << EOF and EOF is considered to be sqlplus input. Received on Thu Jan 09 2003 - 20:13:02 CET