RE: [RE: COPY vs. INSERTS

There is a BIG difference.

NUMBER can store a floating point number NUMBER(38) will only store interger numbers.

i.e. it will truncate the decimals.

George.

> -----Original Message-----
> From: "Alex Hillman" <alex_hillman_at_physia.com>
> [mailto:alex_hillman_at_physia.com]
> Sent: Friday, May 26, 2000 10:40 PM
> To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> <ORACLE-L_at_fatcity.com>]
> Subject: RE: [RE: COPY vs. INSERTS
>
>
> What do you think is the difference between Oracle types NUMBER and
> DECIMAL(38) - answer is NONE.
>
> Alex Hillman
>
> -----Original Message-----
> Sent: Friday, May 26, 2000 3:08 PM
> To: Multiple recipients of list ORACLE-L
>
>
> One important note regarding SQLPLUS COPY utility that can
> make this less
> utilitarian is as follows from SQL*Plus 3.1 User Guide and Reference:
> "Note: To enable the copying of data between ORACLE and non-ORACLE
> databases,
> NUMBER columns are changed to DECIMAL columns in the
> destination table.
> Hence, if you are copying between ORACLE databases, a NUMBER
> column with no
> precision will be changed to a DECIMAL(38) column. When
> copying between
> ORACLE databases, you should use SQL commands (CREATE TABLE
> AS and INSERT)
> or
> you should ensure that your columns have a precision specified."
>
> Milan Rahman
> Senior Oracle DBA
> Oracle Applications DBA
> SageLogix, Inc.
> Greenwood Village, Colorado
>
> http://www.sagelogix.com
>
> --
> Author: Milan Rahman
> INET: milan_rahman_at_MailAndNews.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 30 2000 - 04:08:06 CDT