Re: Generate list of reserved words for Oracle versions?

I had already found a more comprehensive list in technet.oracle.com, at
http://technet.oracle.com/doc/server.804/a58234/vol2_wor.htm#421705

There are a bunch of lists in print, some including keywords, some for C, some for OCI. What it boils down to is the need to avoid a bunch of words and symbols for column names etc., that could bite us later. When you're coming off another database product you can be surprised by some of these.

I would trust the internal table of the parser in the product over anything in print, usually. I don't think we can get at it, though. Documentation can help also, by indicating what *may* be a reserved or key word in the future.

For example the string "REF" is in the webpage I cite here, but not in the one you included in your append.

Chris

In article <37f8da91.19714918_at_newshost.us.oracle.com>,   jkallman_at_us.oracle.com wrote:
> On Mon, 04 Oct 1999 16:11:44 GMT, chrisoc_at_ans.net wrote:
>
> >
> >
> >Are the reserved words for Oracle stored in a table or view
> >within Oracle itself, or can they be found online (Unix)
> >in any way?
> >
> >We are converting from another database product using scripts
> >that are designed to convert to Oracle 7, but we will have
> >to use them on Oracle 8.1.5. There are some new reserved words
> >at O8.
> >
> >
>
> The list of Oracle reserved words is contained in Appendex C of the
> Oracle8i SQL Reference manual.
>
> Available on the Oracle Technology Network at:
>
> http://technet.oracle.com/doc/server.815/a67779/ap_keywd.htm#617080
>
> >Anyway, in general, this would be useful to know about.
> >
> >Chris O'Connor
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> Thanks!
>
> Joel
>
> Joel R. Kallman
> Oracle Service Industries
> Columbus, OH http://govt.us.oracle.com
> jkallman@us.oracle.com http://www.oracle.com
>
> ----
> The statements and opinions expressed here are my own
> and do not necessarily represent those of Oracle Corporation.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 05 1999 - 09:14:45 CDT