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: Sybrand Bakker <postbus_at_sybrandb.demon-verwijderdit.nl>
Date: Wed, 28 Aug 2002 22:18:10 +0200
Message-ID: <q87qmuohdc990odqa1sb4v1a8c47utjhaf@4ax.com> 





On Wed, 28 Aug 2002 11:46:52 +0200, Billy Verreynne
<vslabs_at_onwe.co.za> wrote:



>MY_NUM is a NUMBER and not a NUMBER(6). This does not make sense to me. 

>Should it not inherit the underlaying datatype (from the NUM6 column)?




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



Hth




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Wed Aug 28 2002 - 15:18:10 CDT












Original text of this message













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