Re: May be Oracle Bug in View

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: vprasad_at_olf.com

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: 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).