SQL Plus

#1

Hello

Doers anyone of you know how to parametrize SQL script ?
I have one in *.sql file and want to have one or more parameters in it, wich
user has to give during usage?

--
Thanks
Pawel Janusz [ST/SD Team]

#2

Czujnik wrote:

Quote:

Doers anyone of you know how to parametrize SQL script ?
I have one in *.sql file and want to have one or more parameters in it, wich
user has to give during usage?

&name I believe. Like: select * from table where foo = &paramName

-Ariel

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Plus

comp.database.oracle comp.database.oracle

SQL Plus - 07-13-2006 , 03:25 AM

Re: SQL Plus - 09-07-2006 , 04:54 AM