-
SqlPlus Searching in Multiple Directories
Hi,
I was wondering. Is it possible to get SqlPlus to search for scripts
in multiple directories?
Ive found advice for setting the directory in the login.sql file for a
single directory reference but not a reference on how to set multiple
directories using SQLPATH.
I have scripts spread across several subdirects. off a root directory.
I would like sqlplus to read for the named script file in the subdirects., this way I dont have to type in lengthy directory strings before the
name of the script file in a sqlplus.
In short, Im trying to run, using START, script files from script files.
Any advice would be greatly appreciated.
ps
Would be better attempted using PL/SQL and if so, is there a site
that gives sample procedures?
-
Yes.. u can set it different directories using colon.
SQLPATH=path1ath2ath3
-
Not entirely on topic, but you could also consider turning those scripts into stored procedures. There are obviously advantages and disadvantages, but I like the arrangement better myself where it is possible.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|