Home » RDBMS Server » Server Administration » Command Line SQL
Command Line SQL [message #371157] Fri, 08 September 2000 19:20 Go to next message
Frederick Tobun
Messages: 1
Registered: September 2000
Junior Member
How can I embed an SQL statement in .bat file OR how to
run a SQL statement from a command line.

Report message to a moderator

Re: Command Line SQL [message #371159 is a reply to message #371157] Sat, 09 September 2000 15:36 Go to previous message
Vjeko
Messages: 15
Registered: August 2000
Junior Member
Hi!
First, write the SQL statment in .sql file and finish it with exit;
(For ex. SELECT sysdate from sys.dual;
exit;)
then write in your .bat file :

sqlplus username/password @sql_file

Good luck!

Report message to a moderator

Previous Topic: About oracle programming (MAKEFILE)
Next Topic: catalog.sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 11:48:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.