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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create table question

Re: Create table question

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 20 Jan 2005 19:13:24 -0800
Message-ID: <41f07354@news.victoria.tc.ca>


Anurag Varma (avdbi_at_gmail.com) wrote:

: A more elegant way would probably be:

: ORA92> create table xyz1 as select xyz.*, cast('OK' as varchar2(10)) d from
: xyz;

Assuming you have the right versions, this is clearly the correct solution. Thanks.

--

This space not for rent.
Received on Thu Jan 20 2005 - 21:13:24 CST

Original text of this message

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