Re: Implicit Column Types with a CREATE AS SELECT

Billy Verreynne <vslabs_at_onwe.co.za> wrote in message news:<akks36$c1c$1_at_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)

I have seen a similar behavior on character data types. Try, create table table1 (col1 char(10));
create table2 as select (select col1 from table1) col2 from dual;

and you get a varchar column for table2. Seems like inline subquery is treated as a function when used in a CTAS but I've never seen any documentation on it. Received on Fri Aug 30 2002 - 11:56:32 CDT