Executing Orac;e script

[balachandar]

Hi,
I want to delete a record from a table called File_Upload.
I need to execute this sql statement from DOS prompt using a batch file. Any idea on how this can be done. The necessary user id and password will have to be passed to this bat file.

Thanks and Regards
Balachandar Ganesan.

 

[LKBrwnDBA]

You could craete an sql script with your sql statements or
try something like this:

REM MyQuery.bat
echo conn uid/pw@db1 >MyQuery.sql
echo select sysdate from dual; >>MyQuery.sql
echo exit MyQuery.sql
sqlplus /nolog @MyQuery.sql

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb