Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Implicit Column Types with a CREATE AS SELECT
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)
-- BillyReceived on Thu Aug 29 2002 - 05:12:40 CDT