DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: inputing a (table/tablespace name) at script level.

  1. #1
    Join Date
    May 2001
    Posts
    39

    Wink inputing a (table/tablespace name) at script level.

    sir,
    i would like to have a simple form of shell script , which can
    take a table or tablespace as input at script level(o/s} and provide me a database o/p at script level.Basically giving an input table name at script level then at sql level.

    pls help .thanks in advance.


    sanctus.
    sanctus

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    I am not sure I understand. Would like to pass parameter from shell script to sql script?

    You can pass parameters to sqlplus after script like
    sqlplus user/pass@db @script.sql param1 param2

    In sql script you reference the parameters as &n where n is the position of parameter, like &1, &2.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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