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

Home -> Community -> Usenet -> c.d.o.server -> Re: reserved keywords for oracle

Re: reserved keywords for oracle

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 09 Oct 2002 20:41:03 GMT
Message-ID: <3DA4943D.1553BBA8@exesolutions.com>


Ionut Filip wrote:

> hi all,
>
> our application allows the user to create/ query it's own tables, columns,
> data.
> There are some situation when oracle will allow the usage of reserved words
> like 'select', 'drop' etc . However we noticed that shortly after that our
> product starts behaving weird. Now, I want to know if there is a function to
> check if a string represents an oracle keyword.
> I could probably get the list of reserved keywords and put it in a table and
> write my own function, but that would mean i have to maintainn that list as
> well as customize it for different oracle versions.
>
> much appreciated

SELECT *
FROM v$reserved_words

Daniel Morgan Received on Wed Oct 09 2002 - 15:41:03 CDT

Original text of this message

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