Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Inarguments to a sqlplus script.

Re: Inarguments to a sqlplus script.

From: Alan Shein <alanshein_at_erols.com>
Date: Mon, 8 Nov 1999 10:27:37 -0500
Message-ID: <806q3t$im9$1@autumn.news.rcn.net>


It's all in how you name the variables in the script. The need to be named &1 &2 &3 and so on. Then, you invoke the script as you have already indicated.

Henrik Otto <ottoh_at_space.se> wrote in message news:3826CF29.24CB_at_space.se...
> How can I read in arguments when starting a script?
>
> example of what I want to do:
> @script arg1 arg2
>
> instead of using accept inside the scripts.
>
> Then use the arguments to query from tables with that name etc.
>
> Thanks for your time.
>
> /Henrik
Received on Mon Nov 08 1999 - 09:27:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US