Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NUMBER(9) UNION NUMBER(9) results in NUMBER(32,32)

NUMBER(9) UNION NUMBER(9) results in NUMBER(32,32)

From: Jos Groot Lipman <glipman_at_tref.nl>
Date: Thu, 13 May 1999 20:50:59 +0200
Message-ID: <MPG.11a53d7fa63055c398968c@news.tref.nl>


We have got two tables with an ID-field which we join in a view like:

create or replace view CAD_VIEW

    as select IDNUMBER from TABLE1
    union
    select IDNUMBER from TABLE2  

In both tables the IDNUMBER is defined identically as NUMBER(9), an integer but in the resulting view the datatype is NUMBER(32,32)

We use this view in another program (AutoCAD) who's Oracle driver has got problems with a NUMBER(32,32)  

Is there a way to force the view to result in a NUMBER(9) column?  

--
J. Groot Lipman
Author of Better WMF and Screen Wintab
home: http://leden.tref.nl/glipman
e-mail: glipman_at_tref.nl Received on Thu May 13 1999 - 13:50:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US