Home » RDBMS Server » Server Utilities » .bat and .sql files
.bat and .sql files [message #71368] Wed, 23 October 2002 04:17 Go to next message
Venkat
Messages: 110
Registered: February 2001
Senior Member
i want to pass on an argument from (.bat) file to (.sql) file....any help from anybody

Report message to a moderator

Re: .bat and .sql files [message #71369 is a reply to message #71368] Wed, 23 October 2002 06:29 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Use %1 %2 etc ... to catch the arguments

and run Ur sql using sqlplus

SQLPLUS [[<option>]] [[connexion]] [[<démarrage>]] ]]

ex: test.bat
sqlplus [[connexion]] @myscipt.sql %1

Report message to a moderator

Re: .bat and .sql files [message #71434 is a reply to message #71368] Thu, 31 October 2002 18:18 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Example of how to pass parameters between batch and sql file is provided Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: .bat and .sql files [message #71988 is a reply to message #71368] Sat, 15 February 2003 02:43 Go to previous message
Amit Patel
Messages: 3
Registered: April 2002
Junior Member
No Message Body

Report message to a moderator

Previous Topic: OCP papers
Next Topic: Exporting objects to SQL statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 08:15:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.