RE: default length for DATE datatype

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 15 May 2008 07:14:59 -0500
Message-ID: <BLU108-W3123DACA4C83309131B03C97C90@phx.gbl>

There is a default value specfied in the ddl script. That what it is. But it is the same default value. And the char sets are the same. thanks.  

Subject: RE: default length for DATE datatypeDate: Thu, 15 May 2008 08:08:05 -0400From: Thomas.Mercadante_at_labor.state.ny.usTo: joe_dba_at_hotmail.com; oracle-l_at_freelists.org

Are the character sets the same on both databases?

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joe SmithSent: Wednesday, May 14, 2008 3:22 PMTo: oracle-l_at_freelists.orgSubject: default length for DATE datatype

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            SOURCE6 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. Connect on the go.

---

Get Free (PRODUCT) RED™ Emoticons, Winks and Display Pics. http://joinred.spaces.live.com?ocid=TXT_HMTG_prodredemoticons_052008

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 15 2008 - 07:14:59 CDT