| "Captured" SQL Query [message #41238] |
Wed, 11 December 2002 15:56  |
Rizwan Qazi
Messages: 135
Registered: August 2002
|
Senior Member |
|
|
I have several long SQL Scripts which are executed at the SQL Prompt. Can someone give me an example how I can "capture" them inside a procedure, function or package so that they can be stored in a database?
Is there any way a SQL script can be stored within a tablespace without a PL/SQL block around it?
I know this is a rather generic question but please do let me know.
Thank You
Rizwan
|
|
|
|
| Re: "Captured" SQL Query [message #41240 is a reply to message #41238] |
Wed, 11 December 2002 16:11  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
Store your script inside a file (test.sql) and place the file in some directory (c:rizwantest.sql).
then from sql prompt type
SQL > @C:rizwantest.sql
gook luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
