Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle reserved and non-reserved keywords

KawuJan 21 2009 — edited Jan 23 2009
Hello,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2009
Added on Jan 21 2009
7 comments
2,747 views