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
Messages: 63
Registered: April 2005

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?


[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
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
When all else fail you could read the fine SQL Reference manual found at:
& 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 Oct 24 19:36:37 CDT 2016

Total time taken to generate the page: 0.07175 seconds