Is User_tab_columns correct?

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Wed, 4 Nov 98 16:45:42 +0200
Message-ID: <AAMY6GsK42@protasov.kiev.ua>

Hi,

I found something interesting with user_tab_columns in Oracle 8.0.3. Try this:

SVRMGR>
SVRMGR> drop table test;
Statement processed.
SVRMGR> drop type t_test2;
Statement processed.
SVRMGR> drop type t_test1;
Statement processed.

SVRMGR>
SVRMGR> create or replace type t_test1 as object
     2> (id integer
     3> );

Statement processed.

SVRMGR>
SVRMGR> create or replace type t_test2 as object
     2> (t2 ref t_test1
     3> );

Statement processed.

SVRMGR>
SVRMGR> create table test
     2> (x t_test2
     3> );

Statement processed.

SVRMGR>
SVRMGR> select column_name,data_type
     2> from user_tab_columns
     3> where table_name='TEST';
COLUMN_NAME                    DATA_TYPE
------------------------------ ------------------------------
X                              T_TEST2
X                              T_TEST1

2 rows selected.
SVRMGR>
SVRMGR> spool off

Column x has two different datatypes. Is this correct?

Andrew Protasov Received on Wed Nov 04 1998 - 08:45:42 CST