Re: List of all Oracle SQL keywords?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Apr 2003 09:29:10 -0700
Message-ID: <2687bb95.0304110829.1dbe2572@posting.google.com>

"Islaw" <islaw_at_adexec.com> wrote in message news:<lYtla.165$3X3.163_at_newssvr16.news.prodigy.com>...
> Hello. This may seem dumb to some, but I'm wondering where I can find a
> complete list of all SQL(and PL/SQL) keywords (SELECT, FROM, IF, etc) for
> Oracle (either 8i or 9i will do.) Purpose being I'm working on a web based
> sqlplus interface and would like to add some syntax highlighting to it.
>
> For that matter what would be a good way to group the different keywords?
> Perhaps group PL/SQL-only words (IF, ELSE, CURSOR, LOOP, etc) with one color
> and Query stuff (SELECT, FROM, WHERE, ORDER/GROUP BY, HAVING, COLUMN, BREAK,
> etc) with another?
>
> Any advice will be appreciated.
> Thanks.

The reserved words for pl/sql can be queried from Oracle using v$reserved_words.

The Oracle SQL reserved words are listed in Appendix C of the SQL Manual.

HTH -- Mark D Powell -- Received on Fri Apr 11 2003 - 11:29:10 CDT