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: QUERY WRITING

Re: QUERY WRITING

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 29 Nov 2004 10:30:37 -0800
Message-ID: <6d8b7216.0411291030.183a7f36@posting.google.com>


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

Original text of this message

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