Oracle reserved and non-reserved keywords
KawuJan 21 2009 — edited Jan 23 2009Hello,
I'm looking for a list of reserved and non-reserved keywords for all Oracle versions starting from 9.
I think Oracle starts at R1, right? So the versions needed would be:
9.1, 9.2
10.1, 10.2 and
11.1
?
I found lists of keywords querying Oracle view V$RESERVED_WORDS
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2048.htm#REFRN30204
here:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_keywd.htm
However, this is only for version 10.2 and it contains only reserved keywords.
I need a list for every maintenance/minor version. This list must contain all keywords in Oracle PL/SQL, not just the reserved ones, but also those which shouldn't be used in certain contexts described by the V$RESERVED_WORDS view (former link) -> probably reserved = 'N'.
Since I don't own a copy of Oracle and definitely not of every minor version, does anyone know where to obtain such lists?
You might want to do me a favor and query that view for me... ;-) (you can send the output to "k w u t z k e AT w e b DOT d e" ... don't forget to mention the version)
From what the view tells me, the SQL statements to query are:
For reserved words:
select keyword from v$reserved_words where reserved='Y' order by keyword;
For all other non-reserved words:
select keyword from v$reserved_words where reserved='N' order by keyword;
Are there any keywords/entities that are neither reserved='Y' nor reserved='N'?
Can anyone help on this issue please?
TIA,
Karsten