Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create table question
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