Home » SQL & PL/SQL » SQL & PL/SQL » Assign select value to variable?
Assign select value to variable? [message #188472] Fri, 18 August 2006 13:04 Go to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Hi,

in MS Sql Server 2000, we can do the following:

DECLARE @Total int
Select @Total = Total from t

How can I do the same in oracle?

Thanks

[Updated on: Fri, 18 August 2006 13:05]

Report message to a moderator

Re: Assign select value to variable? [message #188474 is a reply to message #188472] Fri, 18 August 2006 13:09 Go to previous message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
When all else fail you could read the fine SQL Reference manual found at:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm
& search for the keyword "INTO"
Previous Topic: How can I find any change on source code whatever packages or types???
Next Topic: Restricting recordset before joining to large table?
Goto Forum:
  


Current Time: Mon Dec 05 12:52:04 CST 2016

Total time taken to generate the page: 0.11535 seconds