Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: List of all Oracle SQL keywords?

Re: List of all Oracle SQL keywords?

From: Roger Jackson <rjackson1_at_hotkey.net.au>
Date: Fri, 11 Apr 2003 21:21:56 +1000
Message-ID: <3e96a563_1@news.iprimus.com.au>


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
>
>
Received on Fri Apr 11 2003 - 06:21:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US