Re: Create table

Yam wrote:
> Hi,
>
> I have a table called tab1 with the following filelds: fld1, fld2 and
> fld3 and I want to create another table tab2 from tab1, with an
> additional field fld0 added at the beginning, i.e. fld0, fld1, fld2 and
> fld3, how can I do that?
>
> Can I use syntax such as create table tabl2 ... as select ... from
> tabl1?
>
> Yam.

Yes. But why did you ask? You could have easily answered the question by trying it.

Unless the syntax you are using includes the words DROP or TRUNCATE the chances of you doing something unrecoverable are nill.

Experiment!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org