Re: Interview Question

From: Reid Lai <reidlai_at_hk.super.net>
Date: 1997/06/08
Message-ID: <01bc73ad$fa2386e0$131440ca@hk.super.net.hk.super.net>#1/1

And also redo log will log down all transaction made by DELETE statement while TRUNCATE will not do so.

Best Regards,

Reid Lai
mailto://reidlai@hk.super.net
mailto://reid_lai@its.swireprops.com.hk
http://www.hk.super.net

Cat10021 <cat10021_at_aol.com> wrote in article <19970607173700.NAA28002_at_ladder02.news.aol.com>...
> 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 Sun Jun 08 1997 - 00:00:00 CDT