Home » SQL & PL/SQL » Client Tools » How to avoid prompt for subsitution variable
How to avoid prompt for subsitution variable [message #244246] Tue, 12 June 2007 02:48 Go to next message
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
Re: How to avoid prompt for subsitution variable [message #244253 is a reply to message #244246] Tue, 12 June 2007 02:55 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way I'm aware of.

Regards
Michel
Previous Topic: How to create a counter using Oracle SQL Developer?
Next Topic: Spool file with date
Goto Forum:
  


Current Time: Tue Dec 06 04:13:16 CST 2016

Total time taken to generate the page: 0.07553 seconds