Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL resrved words
PL/SQL resrved words [message #203787] Thu, 16 November 2006 05:33 Go to next message
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
Member
hi Everybody
On the Oracle site there are more than 800 Keywords or reserved words are given but which of these keywords you cannot use as variable names in Procedures(Pl/Sql). I mean which of these words will give compile time error. Beacuse I tried some of them. It allows some it and it gives errors for some of the keywords. So how exactly I will get to know these names you cannot have as variable names in pl/sql.



Thanks in advance.
Re: PL/SQL resrved words [message #203789 is a reply to message #203787] Thu, 16 November 2006 05:53 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know (also, I'm too lazy to search for it), but WHY would anyone, among vast millions of possible alphanumeric (plus some additional, special) character combinations use Oracle reserved word as a variable name?
Re: PL/SQL resrved words [message #203790 is a reply to message #203787] Thu, 16 November 2006 05:55 Go to previous messageGo to next message
amit_kiran
Messages: 50
Registered: July 2006
Location: UK
Member

Hi..

I have collected some of variable names which you cannot use in Procedures(Pl/Sql).
Kindly check it....

Thanks.
Amit.
Re: PL/SQL resrved words [message #203796 is a reply to message #203790] Thu, 16 November 2006 06:13 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Just check here for Reserved Words & Keywords or check in V$RESERVED_WORDS.
Previous Topic: Help in Join
Next Topic: Yes or NO
Goto Forum:
  


Current Time: Fri Dec 09 11:37:11 CST 2016

Total time taken to generate the page: 0.06972 seconds