DosTips.com

Thank you very much both of you. It works.

Dear All,

I have tried to make dos batch file for sqlplus program.

sqlplus / as sysdba;
update
UPDATE
MyTable
SET MyColumn ='Y'
WHERE MyColumn ='N';
COMMIT;


But, when I run bath file only sql prompt will appear (SQL>) rest of the command will not functionning..

Dear All,

I have to create a batch file containing following syntax. How can I create batch file. Please help.

sqlplus / as sysdba;
sql> update
sql> MyTable
sql> SET MyColumn ='Y'
sql> WHERE MyColumn ='N';
sql> COMMIT;