I should have told the actual problem , any how here I go with it ..
create table test (col1 double precision, col2 double precision);
Table created.
create view test_view (col1, col2, col3) as select col1 , col2 , col1+col2 from test;
View created.
desc test_view;
Name Null? Type
----------------------------------------------------------------- --------
------------------------
COL1 FLOAT(126)
COL2 FLOAT(126)
COL3 NUMBER
when the col1 and col2 are combined together which datatype of both columns are DOUBLE
PRECISION,
I am expecting the third col3 datatype to be DOUBLE PRECISION.
But it is getting converted to NUMBER instead. I am trying to access the view using my
OCI program
and having a problem in getting the right values , Hope this time you guys understand
what am
I trying to hightlight ..
Veera
Regina Harter wrote:
> I am uncertain why you believe this to be a problem. Its using the default
> number size (38 I think) but it's not really storing it anywhere, it's just
> keeping the definition, so what do you care how big it thinks it is? Its
> plenty large enough to handle any sum of to number(20)s.
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Veera Prasad
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
