Execute delete queries using batch file?

Question

I am using Oracle11g. I have below two sql queries.

Delete from TableA;
Delete from TableB;
Delete from TableC;
Delete from TableD;
Delete from TableE;

Now how can i create a batch file to run this script By passing the credentials to connect to DB and delete using above queries?

Thanks!

I assume the above queries are just sample. Still TRUNCATE is the best option to delete the entire content of table. (Unless, a ROLLBACK is not needed) — Maheswaran Ravisankar
– Maheswaran Ravisankar, Commented Feb 4, 2014 at 11:34

Ronnis · Accepted Answer · 2014-02-04 11:31:45Z

1

Add the statements to a file, say "delete.sql". To execute the statements in the file, type:

sqlplus username/password@tns_name_of_your_db @delete.sql

...or simply add that into a .BAT file.

PS. Remember to add a COMMIT; statement.

PS2. Make sure the last line of "delete.sql" is empty (blank line).

answered Feb 4, 2014 at 11:31

Ronnis

12.9k3 gold badges37 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user755806 Over a year ago

Ronnis, can this batch file be run on any machine? Or does the machine should have any software installed? Because i have to do it to delete in remote database..

Ronnis Over a year ago

You need Oracle Client to run SQL*Plus.

Collectives™ on Stack Overflow

Execute delete queries using batch file?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related