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: 25571
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: 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