Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: QUERY WRITING
Mladen Gogala <gogala_at_sbcglobal.net> wrote in message news:<pan.2004.11.26.08.20.33.91600_at_sbcglobal.net>...
> of course: TRUNCATE TABLE will give you the expected results.
> If your table is called MYTABLE you should execute the following:
> TRUNCATE TABLE MYTABLE;
> AS SELECT PRODUCT, ENGLANd+GERMANY+FRANCE+USA
> /
>
> Don't forget the semicolon at the end of the 1st line or the
> statement will not work. You don't have to thank me.
Man, that's harsh... Received on Mon Nov 29 2004 - 12:30:37 CST