How to write batch file for sqlplus

[Indra Rai]

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;

[Indra Rai]

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..

[einstein1969]

hi Indra,

you can save the sql commands in a file. For example in update.sql write...

update.sql:

Code: Select all

UPDATE MyTable SET MyColumn ='Y' WHERE MyColumn ='N';
COMMIT;

then in a batch file update.cmd, you can start the sql commands file.
update.cmd:

Code: Select all

sqlplus / as sysdba @update.sql

einstein1969

[Aacini]

You may create a TEXT file with these lines (for example UPDATE.TXT):

Code: Select all

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

... and then "execute it" this way: CMD < UPDATE.TXT

Antonio

[Indra Rai]

Thank you very much both of you. It works.