OraFAQ Forum: Enterprise Manager » Entering variables into Sqlworksheet in Enterprise Manager

Home » RDBMS Server » Enterprise Manager » Entering variables into Sqlworksheet in Enterprise Manager

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

Entering variables into Sqlworksheet in Enterprise Manager [message #243516]

Thu, 07 June 2007 10:42

lawlade
Messages: 59
Registered: May 2007
Location: LAUREL, MARYLAND

Member

I am trying to run Plsql script in sqlworksheet that prompt for values of several variables. I don't want to hard code these variables in the script. Is there a way one can do this from sqlworksheet?

Someone please help!

Report message to a moderator

Re: Entering variables into SQL Worksheet in Enterprise Manager [message #243639 is a reply to message #243516]

Fri, 08 June 2007 02:57

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

See Help -> Contents -> SQL*Plus -> Differences Between SQL*Plus Worksheet and SQLPlus Line Mode:

"If there are any prompt characters "&" in a script, SQL*Plus treats it as a "define" prompt."

So, you will have to DEFINE your variables before executing the script. Examples:

DEFINE tab=dual
SELECT * FROM &tab;

DEFINE tab=dual
@selfrom

Report message to a moderator

Previous Topic:	Rest Time Zone
Next Topic:	Changing the IP address of Grid Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 02 08:33:39 CDT 2025