| How to create Batch file for sql [message #196057] |
Tue, 03 October 2006 21:45  |
DeoRaj
Messages: 1
Registered: October 2006
Location: Japan
|
Junior Member |
|
|
Hello,
I am new to oracle and SQL.
I want to create a batch file to update records.
How can I create batch file for oracle database.
Please help me.
Thanks,
DeoRaj
|
|
|
|
| Re: How to create Batch file for sql [message #196067 is a reply to message #196057] |
Wed, 04 October 2006 00:23  |
chinni_00
Messages: 30
Registered: October 2005
|
Member |
|
|
Hi
Just Write down the Respective queries in the notepad or a Wordpad and then save the file with the extension of .sql, to Execute this file you write down an other file specifying the Username and Password with the Database to which you want to connect and the file you want to execute in this way
'@ test.sql' if both the files are from the same directory no need of path save this file with the extension .bat and by double clicking this file the query will be executed and the respective action will be performed.
HTH
Regards
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
