Re: Generate list of reserved words for Oracle versions?

There is a dynamic view called

    v$reserved_words
which looks rather promising.

639 entries at present (8.1.5.0)

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

chrisoc_at_ans.net wrote in message <7td147$uub$1_at_nnrp1.deja.com>...
>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 - 10:59:11 CDT