Re: TRUNCATE

From: ALEX J JENTILUCCI <ALEXJENT_at_prodigy.net>
Date: Sat, 18 Apr 1998 16:48:11 -0500
Message-ID: <6hb7iu$1844$1@newssvr04-int.news.prodigy.com>

Note that in order to use TRUNCATE, you must own the table you wish to truncate.
So in a production environment you might have a problem.

Alex

Sbaiz wrote in message <01bd69de$fac54390$b8cd5997_at_sbaiz>...
>Hi all,
>I must execute the statement "DELETE * FROM TABLE" periodically, run-time,
>with a store procedure.
>There is a way to execute the statement SQLPlus TRUCATE TABLE, run-time,
>in a store procedure.
>
>Thank you in advance.
>Pierluigi S.
>
Received on Sat Apr 18 1998 - 16:48:11 CDT