A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Is this an intialization?
Joined: Jun 22, 2005
Jul 08, 2012 23:51:19
select @myvariable = 'A'
Is this an initialization in query language?
Keep Smiling Always — My life is smoother when running silent. -paul
The Linux Documentation Project
Joined: Aug 22, 2010
Jul 09, 2012 01:21:42
This certainly isn't valid in PL/SQL, and I'd say not even in sql*plus scripts. I'd say it looks like TransactSQL, but I don't have any experience with it.
Are you porting code from other databases to Oracle? In PL/SQL, you can assign values to variables using the assignment operator:
declare myvariable varchar2(10); begin myvariable := 'A'; end; /
I agree. Here's the link:
subject: Is this an intialization?
Why we live?
Netscape7.1 and window.createPopup()
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013