What is the datatype and precision of Oracle NULL column?

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer