rjackson1_at_hotkey.net.au said...
> The view V$RESERVED_WORDS (Oracle 8i and above) provides a complete list of
> the reserved / key words in Oracle.
>
> HTH
>
> Roger.
>
> "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.
> >
> > --
> > Islaw
> >
>
Make that "almost complete list" ... at least when I do it in 8.1.7, I
don't see some PL/SQL keywords that I use frequently ... like LOOP,
ELSIF, EXCEPTION (but do see EXCEPTIONS), and probably some others.
--
/Karsten
DBA > retired > DBA
Received on Fri Apr 11 2003 - 10:50:13 CDT
