OraFAQ Forum: Client Tools » How to avoid prompt for subsitution variable

Home » Other » Client Tools » How to avoid prompt for subsitution variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to avoid prompt for subsitution variable [message #244246]

Tue, 12 June 2007 02:48

kukreja
Messages: 33
Registered: February 2007

Member

Hi

If I passing the variable to sqlplus file from OS.
Like
sqlplus test/test @test.sql A B C

In sql file

Insert into test values(&1,&2,&3);

Is there anyway , so that even if i m not passing value of &2 and &3, like
sqlplus test/test @test.sql A
it not prompt for value of 2 and 3 ?

Help me solving this problem

Report message to a moderator