Re: Defaulting the parameters in a sqlplus script.

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 19 May 2004 17:01:08 +0200
Message-ID: <40ab76a0$0$8182$626a14ce@news.free.fr>

"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.
>
> --
> Galen Boyer

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

Regards
Michel Cadot Received on Wed May 19 2004 - 10:01:08 CDT

This message: [ Message body ]
Next message: Matt: "Interesting Oracle Data Load Scenario"
Previous message: madodba: "Re: Seg fault while using loadjava with 10g"
In reply to: Galen Boyer: "Defaulting the parameters in a sqlplus script."
Next in thread: Galen Boyer: "Re: Defaulting the parameters in a sqlplus script."
Reply: Galen Boyer: "Re: Defaulting the parameters in a sqlplus script."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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