Home » RDBMS Server » Server Administration » Re: Running a file from within another file??
Re: Running a file from within another file?? [message #375109] Thu, 26 July 2001 18:18
andrew again
Messages: 2577
Registered: March 2000
Senior Member
simply execute it. e.g. file1.sql calls file2.sql

file1.sql
---------
select * from my_tab;
prompt Calling file 2 now!
@@file2.sql
prompt We are back in file 1 now!

Using '@' or 'start' makes sqlplus look for the named file in the default directory or in SQL_PATH env variable.
Using '@@' looks for the file in the same location as file1.sql

Report message to a moderator

Previous Topic: Cannot create Triggers on objects owned by SYS-Need help fast
Next Topic: How to copy tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:34:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.