Re: Is this a bug?

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 Received on Thu Jan 04 2007 - 10:09:31 CST