Home » SQL & PL/SQL » SQL & PL/SQL » How to create Batch file for sql
How to create Batch file for sql [message #196057] Tue, 03 October 2006 21:45 Go to next message
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 Go to previous messageGo to next message
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
Re: How to create Batch file for sql [message #196123 is a reply to message #196067] Wed, 04 October 2006 03:56 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you'd like to schedule this job for later execution, search for DBMS_JOB or DBMS_SCHEDULE.
Previous Topic: How to set OFF the option "Display Substitution Variables"
Next Topic: substr
Goto Forum:
  


Current Time: Thu Dec 08 05:59:33 CST 2016

Total time taken to generate the page: 0.10952 seconds