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: Interview Question

Re: Interview Question

From: Cat10021 <cat10021_at_aol.com>
Date: 1997/06/07
Message-ID: <19970607173700.NAA28002@ladder02.news.aol.com>#1/1 







Interview question:



What is the difference between DELETE and TRUNCATE on a table.



Answer:



Truncate release the space occupied immediately to Oracle. Delete does not
.


Delete will fire on delete triggers while truncate will not . DELETE is a
DML



while TRUNCATE is a DDL statement.



Ja Uhm


juhm_at_mobile.bam.com
Received on Sat Jun 07 1997 - 00:00:00 CDT












Original text of this message













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