SqlPlus Searching in Multiple Directories
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SqlPlus Searching in Multiple Directories

  1. #1
    Join Date
    Mar 2004
    Posts
    9

    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?

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Yes.. u can set it different directories using colon.
    SQLPATH=path1ath2ath3

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width