default length for DATE datatype
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 14 May 2008 14:21:32 -0500
How can the same table in two different databases have a
differentDEFAULT_LENGTH for the DATE datatype? One database is dev and the
otheris UAT. Both databases are on the same server and same oracle home
10.2.0.3.0 EE.
> select table_name, column_name , default_length from user_tab_columns where
> table_name ='TABLE';
TABLE_NAME COLUMN_NAME
DEFAULT_LENGTH------------------------------ ------------------------------
--------------TABLE PARTNER_IDTABLE EMAIL_ADDRESSTABLE
START_DATE 22TABLE
MARKETING_PREFERENCES_FLAGTABLE END_DATE
22TABLE SOURCE
6 rows selected.
> select table_name, column_name , default_length from user_tab_columns where
> table_name ='TABLE';
TABLE_NAME COLUMN_NAME
DEFAULT_LENGTH------------------------------ ------------------------------
--------------TABLE PARTNER_IDTABLE EMAIL_ADDRESSTABLE
START_DATE 27TABLE
MARKETING_PREFERENCES_FLAGTABLE END_DATE
27TABLE SOURCE
thanks.
_________________________________________________________________
With Windows Live for mobile, your contacts travel with you.
http://www.windowslive.com/mobile/overview.html?ocid=TXT_TAGLM_WL_Refresh_mobile_052008
Other related posts:
