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

Home -> Community -> Mailing Lists -> Oracle-L -> syntax fro nologging on delete statemnt Oracle 8.1.7

syntax fro nologging on delete statemnt Oracle 8.1.7

From: John Dunn <jdunn_at_sefas.com>
Date: Thu, 27 Jan 2005 11:31:36 -0000
Message-ID: <000501c50463$c3276720$3e04050a@johnman>


What does this not work?

delete from mytable where mytable.mynum = 20041212121212 nologging;

     *
ERROR at line 1:
ORA-00933: SQL command not properly ended

delete from mytable nologging;

works fine

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 27 2005 - 06:32:53 CST

Original text of this message

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