Re: List of all Oracle SQL keywords?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 12 Apr 2003 11:14:38 -0500
Message-ID: <usmsnr01r.fsf@hotpop.com>

On Fri, 11 Apr 2003, rjackson1_at_hotkey.net.au wrote:
> The view V$RESERVED_WORDS (Oracle 8i and above) provides a complete
> list of the reserved / key words in Oracle.

    SQL> select keyword from v$reserved_words

         where keyword like 'A%' and rownum < 3;

    KEYWORD

---

    ACCESS
    ACCOUNT Sometimes I can use them without Oracle barking, like so:

    SQL> create table account (fld number);

    Table created.

And sometimes it barks, like so:

    SQL> create table ACCESS (fld number);     create table ACCESS (fld number)

                 *

    ERROR at line 1:
    ORA-00903: invalid table name

Guess I'll go read up on Oracle's definition of keyword.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Sat Apr 12 2003 - 11:14:38 CDT