0

I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it
UPDATE sal SET sal= sal+3000
select * from ..................
insert into table tab_name values(........)
insert into table tab_name values(........)
insert into table tab_name values(........)
.........so on

Is there any SQL query like that if I ran it by provide the path ( D:\SQL.txt) of the notepad in the query itself it will execute one by one command from the notepad.
If it is not there in the SQL can I do it in Oracle DB or DB2.

2
Contributors
5
Replies
6
Views
9 Years
Discussion Span
Last Post by Shanti C
0

sorry,,,
the above two are for inserting the data from notepad to mysql table...
please ignore them...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.