Home » SQL & PL/SQL » SQL & PL/SQL » How can you keep your SQL Session active?
How can you keep your SQL Session active? [message #37527] Wed, 13 February 2002 02:23 Go to next message
Majad Hussain
Messages: 1
Registered: February 2002
Junior Member
I want to run a number of SQL scripts which will contain exit commands when the script is complete.
But when the first script finishes the SQL session is killed and returns to the command prompt.

How can i maintain the SQL session and still run multiple SQL scripts ?

Report message to a moderator

Re: How can you keep your SQL Session active? [message #37541 is a reply to message #37527] Wed, 13 February 2002 10:02 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
I ended up taking the exits out. The ones I couldn't I ended up writing a script like:

sqlplus username/password@alias @script1.sql
sqlplus username/password@alias @script2.sql

and so on.

Report message to a moderator

Previous Topic: View Text
Next Topic: How to calculate the difference between dates on different rows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 11 05:48:49 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.