Re: Is this a bug?

Maxim Demenko wrote:
> Anurag Varma schrieb:
>
> > The bug (or inconsistency as you might want to call it) is that oracle
> > should
> > not allow a column name and datatype to be of the same name IF the
> > column
> > name is not enclosed in double quotes.
> >
> > So create table test (timestamp timestamp); should throw an error
> > since all other datatypes do throw an error.
> >
>
> You are far too optimistic ;-)
>
> scott_at_ORA102> create table t(id number,bfile bfile);
>
> Table created.
>
> scott_at_ORA102> drop table t;
>
> Table dropped.
>
> scott_at_ORA102> create table t(id number,clob clob);
>
> Table created.
>
> scott_at_ORA102> drop table t;
>
> Table dropped.
>
> scott_at_ORA102> create table t(id number,blob blob);
>
> Table created.
>
> scott_at_ORA102> drop table t;
>
> Table dropped.
>
> scott_at_ORA102> create table t(id number,nchar nchar);
>
> Table created.
>
> scott_at_ORA102> drop table t;
>
> Table dropped.
>
>
> In all the cases behaviour with plsql units referencing the table is
> identical to those with timestamp...
>
> Best regards
>
> Maxim

Thanks for the correction.

:)

Anurag Received on Thu Jan 04 2007 - 10:31:45 CST