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