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

Home -> Community -> Usenet -> c.d.o.server -> Re: Implicit Column Types with a CREATE AS SELECT

Re: Implicit Column Types with a CREATE AS SELECT

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 29 Aug 2002 12:12:40 +0200
Message-ID: <akks36$c1c$1@ctb-nnrp2.saix.net>


Sybrand Bakker wrote:

> The last statement is an inline view. Views do not inherit scale and
> precision , they only inherit datatype

Thanks Sybrand. You know the reasoning behind the logic for this? Or any otherwise to influence scale and precision when dealing with creating implicit columns? (btw, I tried stored proc functions and user defined data types with similar results)

--
Billy
Received on Thu Aug 29 2002 - 05:12:40 CDT

Original text of this message

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