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

    SqlPlus Searching in Multiple Directories


    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.

    Would be better attempted using PL/SQL and if so, is there a site
    that gives sample procedures?

  2. #2
    Join Date
    Nov 2005
    Yes.. u can set it different directories using colon.

  3. #3
    Join Date
    Aug 2002
    Colorado Springs
    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