Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> NUMBER(9) UNION NUMBER(9) results in NUMBER(32,32)
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