Number datatype and union

From: Mauro Bertapelle <MC1523_at_mclink.it>
Date: 1997/07/12
Message-ID: <868718735.MC1523@mclink.it>#1/1

If you look at the example below you'll see that the field F1 wich is declared as NUMERIC(4,0) in table T1 and T2, became a NUMERIC without scale and precision.

I'm new to Oracle, so I'm asking if I'm doing something wrong, or if you know this as a normal behaviour for Oracle.

I'm using Oracle 7.3.2 on a Sun with Solaris 2.5.1

CREATE TABLE T1 (

        F1 NUMERIC(4,0),
        F2 VARCHAR2(20)

);
CREATE TABLE T2 (

        F1 NUMERIC(4,0),
        F2 VARCHAR2(20)

);

CREATE OR REPLACE VIEW MYVIEW(F1,F2)
  AS SELECT F1, F2 FROM T1
  UNION ALL
  SELECT F1, F2 FROM T2; DESCRIBE T1;

Name                            Null?    Type


------------------------------- -------- ----

F1                                       NUMBER(4)
F2                                       VARCHAR2(20)

DESCRIBE T2;
Name                            Null?    Type


------------------------------- -------- ----

F1                                       NUMBER(4)
F2                                       VARCHAR2(20)

DESCRIBE MYVIEW;
Name                            Null?    Type


------------------------------- -------- ----

F1                                       NUMBER
F2                                       VARCHAR2(20)
 

Received on Sat Jul 12 1997 - 00:00:00 CDT