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.
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!
Previous Topic: About oracle programming (MAKEFILE)
Next Topic: catalog.sql
Goto Forum:
  


Current Time: Thu Mar 28 15:28:58 CDT 2024