Re: Is this a bug?

Valentin Minzatu wrote:
> ... or go even further and run:
>
> SELECT DISTINCT owner, column_name, data_type
> FROM dba_tab_columns
> WHERE column_name IN (SELECT keyword
> FROM v$reserved_words) AND owner LIKE
> 'SYS%';
>

To me, this explains why you can create columns with certain reserved words. If Oracle precluded you from doing so, then the Data Dictionary would break.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown