OraFAQ Forum: Client Tools » Controlling prompt based on previous parameter

Home » Other » Client Tools » Controlling prompt based on previous parameter (Oracle 11gR2)

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

Controlling prompt based on previous parameter [message #581575]

Tue, 09 April 2013 01:39

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

Report message to a moderator

Re: Controlling prompt based on previous parameter [message #581592 is a reply to message #581575]

Tue, 09 April 2013 02:28

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is your client tool? SQL*Plus?

Regards
Michel

Report message to a moderator

Re: Controlling prompt based on previous parameter [message #581595 is a reply to message #581592]

Tue, 09 April 2013 02:51

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

sql developer 3.2.

Report message to a moderator

Re: Controlling prompt based on previous parameter [message #581785 is a reply to message #581595]

Wed, 10 April 2013 12:15

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

We (SQL Developer) follow the same rules as SQL*Plus when it comes to substitution (&, &&) variables.

Report message to a moderator

Previous Topic:	ORA-06502 in SQL*Plus, not in Toad
Next Topic:	Sql developer startup is slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 00:44:29 CST 2025