RE: Create Table..As Select: Number formats

>I'm trying to create a table using 'Create
>Table...As Select...'
>
>The contents will then be exchanged into a
>partitioned table, so they need
>to have the same names and datatypes.
>
>Some of the columns in the created table are
>populated with zeroes & will
>be updated after the partition exchange, one of the
>columns is populated
>with a decode that returns a single digit number.
>
>The problem is that I need particular number
>formats in these columns -
>the one-digit column should be a number(1,0) and
>the others should be
>number(12,4). I can't specify column types in
>create table...as select, so
>how else can I force the columns to a particular
>format?
>
>
>Any ideas much appreciated.
>
>Cheers
>Simon Anderson

Simon,

   I don't think that there is any problem here. Specifying the number of digits is largely cosmetic - consider it as a default mask. It doesn't affect how data is stored inside the tables AFAIK.

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).