What is the datatype and precision of Oracle NULL column?

advertisements

_____________________________________________________________________________________________________________________

Do you know the datatype and precision of Oracle Null column?

It is Varchar2 with 0 as the precision.

SQL> create view test_vw as select null x from dual;

View created.

SQL> desc test_vw

Name Null? Type

---------------------------------------- ------- --------

X VARCHAR2

1 select table_name, column_name, data_type, data_length

2 from user_tab_columns

3* where table_name ='TEST_VW'

SQL> /

TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH

--------------- --------------- --------------- -----------

TEST_VW X VARCHAR2 0

_____________________________________________________________________________________________________________________

A visitor from Kuala lumpur viewed 'Data Pump impdp expdp : SQLFILE option to extract ' 23 mins ago

A visitor from Kuala lumpur viewed 'Reset/Modify/alter Oracle sequence nextval, currva' 1 hr 39 mins ago

A visitor from Ballwin viewed 'How to Find out / Check SGA and PGA size of Oracle' 2 hrs 46 mins ago

Archive