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

Home -> Community -> Usenet -> c.d.o.server -> Re: Defaulting the parameters in a sqlplus script.

Re: Defaulting the parameters in a sqlplus script.

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 19 May 2004 10:21:15 -0500
Message-ID: <ud650sax7.fsf@standardandpoors.com>


On Wed, 19 May 2004, micadot{at}altern{dot}org wrote:
>
> "Galen Boyer" <galenboyer_at_hotpop.com> a écrit dans le message
> de news:ulljosfg5.fsf_at_standardandpoors.com...

>> Is this possible, so that you don't have to pass all
>> parameters at the command-line?  I'm on 9i if there are any
>> later features for this.
>>

>
> You can use "define" in your login.sql to default the parameter
> value: define 1="first parameter" define 2="second parameter"
> ...

Yeah,

I didn't really want to do it that way, but ...

-- 
Galen Boyer
Received on Wed May 19 2004 - 10:21:15 CDT

Original text of this message

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