Re: SQL Batch File
From: Ognjen Antonic <ognjen.antonic_at_ogo.homeip.net>
Date: Wed, 8 Jan 2003 22:55:10 +0100
Message-ID: <171T9.2570$tQ1.127672_at_news.siol.net>
Date: Wed, 8 Jan 2003 22:55:10 +0100
Message-ID: <171T9.2570$tQ1.127672_at_news.siol.net>
Make two files:
One containing sql script, another being Unix shell script runing sqlplus:
example:
file select.sql:
select sysdate from dual;
exit;
file select.sh:
sqlplus scott/tiger_at_database @select.sql
Regards,
Ognjen Antonič - Ogo
"Gaser Nadeem" <gsrnadeem_at_mrcc.aast.edu> je napisal v sporočilo
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
>
>
Received on Wed Jan 08 2003 - 22:55:10 CET