Re: New reserved words in Oracle 9

On Wed, 2 Jan 2002 19:51:22 -0000, "Mark Bowler" <m.bowler_at_ukonline.co.uk> wrote:

>Hi,
>
>I was hoping that someone could help me.
>
>Does anyone know if there are any new reserved words in Oracle 9 since
>Oracle 8, and if so, what they are?
>
>I've tried looking in the documentation but I'm not having much luck,
>although I can find a list of all the reserved words.

Do you mean the PL/SQL reserved words that are listed in an appendix of the PL/SQL User's Guide?

I don't think the delta list is given anywhere. Since there is a V$RESERVED_WORDS view, I presume that with an 8i and 9i DB side-by-side, and a database link, you can do something like

select keyword from v$reserved_words
minus
select keyword from v$reserved_words_at_older_db;

(I'll try it myself at the office tomorrow if nobody's turned up a list by then.)

John

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/