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: 25571
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: required query
Next Topic: Help Needed on Conditional Select Statement (CASE?)
Goto Forum:

Current Time: Sun Aug 20 12:29:53 CDT 2017

Total time taken to generate the page: 0.06277 seconds