Home » SQL & PL/SQL » Client Tools » Controlling prompt based on previous parameter (Oracle 11gR2)
Controlling prompt based on previous parameter [message #581575] Tue, 09 April 2013 01:39 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Dear Friends

I need to accept value for some variables using substitution variable. I have a number of variables for which I need to take the value on run time. I need to prompt a parameter based on the value provided earlier.

For example;
There is prompt to enter country. If the user enters country as India it should prompt for the state else it should not prompt for state.

How can this be handled in SQL?

Thanks
RIdhi
Re: Controlling prompt based on previous parameter [message #581592 is a reply to message #581575] Tue, 09 April 2013 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your client tool? SQL*Plus?

Regards
Michel
Re: Controlling prompt based on previous parameter [message #581595 is a reply to message #581592] Tue, 09 April 2013 02:51 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
sql developer 3.2.
Re: Controlling prompt based on previous parameter [message #581785 is a reply to message #581595] Wed, 10 April 2013 12:15 Go to previous message
thatjeffsmith
Messages: 40
Registered: July 2009
Location: Raleigh, NC
Member

We (SQL Developer) follow the same rules as SQL*Plus when it comes to substitution (&, &&) variables.
Previous Topic: ORA-06502 in SQL*Plus, not in Toad
Next Topic: Sql developer startup is slow
Goto Forum:
  


Current Time: Fri Nov 28 20:50:05 CST 2014

Total time taken to generate the page: 0.10800 seconds