Pass unix variable to sqlplus

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Vincento Harris
    #1

    Pass unix variable to sqlplus

    Oracle 8.1.7.4 on Hp Unix 11i
    I am attempting to pass unix parameters on to sql plus
    I did read on technet that with 9i it is very straightforward

    Example script name whoisit
    Pass sid 23
    whoisit 23
    returns


    Vincento .....

    Thanks for your time

    Vince
    Tags: None
    • Frank van Bortel
      #2
      Re: Pass unix variable to sqlplus

      Vincento Harris wrote:
      Oracle 8.1.7.4 on Hp Unix 11i
      I am attempting to pass unix parameters on to sql plus
      I did read on technet that with 9i it is very straightforward
      >
      Example script name whoisit
      Pass sid 23
      whoisit 23
      returns
      >
      >
      Vincento .....
      >
      Thanks for your time
      >
      Vince
      sqlplus uid/paswd@connect @script param1[..param2]
      script:
      &1 == param1, &2 == param2, etc

      SQL*Plus Users Guide & Reference
      --

      Regards,
      Frank van Bortel

        Comment

        Previous template Next
        Working...