OraFAQ Forum: SQL & PL/SQL » Select Variable

Home » SQL & PL/SQL » SQL & PL/SQL » Select Variable

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

Select Variable [message #19565]

Thu, 28 March 2002 12:07

Neil Jackson
Messages: 2
Registered: March 2002

Junior Member

Hi,

I'm new to Oracle but use another well know database where it is very easy to select the value of a variable to the screen, I was hoping some could give me a clue how to do something similar to below:

Thanks in advance
Neil

SQL>declare @testOutput varchar(20);
2 select @testOutput = 'hello';
3 select @testOutput;
4 /

hello

SQL>

Report message to a moderator

Re: Select Variable [message #19567 is a reply to message #19565]

Thu, 28 March 2002 12:34

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

sql> var testoutput varchar2(10);
 
sql> exec :testoutput := 'hello';
 
PL/SQL procedure successfully completed.
 
sql> print testoutput
 
TESTOUTPUT
--------------------------------
hello

Report message to a moderator

Previous Topic:	variables in where clause
Next Topic:	Execute Package.Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 04:07:32 CDT 2024