OT RE: TRUNCATE IN PL/SQL ( a.k.a The Thread that Will Not Die )

I
personally notice a bunch of peole giving Chris their two cents on

a
fairly frequent basis.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Bowes, Chris   [mailto:Chris.Bowes_at_kosa.com]Sent: Thursday, June 21, 2001 4:36   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   TRUNCATE IN PL/SQL
  Yes, he does.  His pay for the incredible amount of help   he provides is the simple thank you that the recipients of the help send him   and he doesn't even ask for that...
  -----Original Message----- Sent:
  Thursday, June 21, 2001 3:16 PM To: Multiple   recipients of list ORACLE-L
  Do you get paid for your daily number of posts?   Waleed
  -----Original Message----- Sent:
  Thursday, June 21, 2001 2:44 PM To: Multiple   recipients of list ORACLE-L
  It should only be drop any table.
"Walking on water and developing software from a specification
  are easy if both are frozen."
  Christopher R. Spence Oracle
  DBA Fuelspot
  This is because you cannot truncate a synonym
"Walking on water and developing software from a specification
  are easy if both are frozen."
  Christopher R. Spence Oracle
  DBA Fuelspot
  You cannot execute DDL in PL/SQL (Never could) unless you use   DBMS_SQL (Pre-8i) or Execute Immediate (8i)

"Walking on water and developing software from a specification
  are easy if both are frozen."
  Christopher R. Spence Oracle
  DBA Fuelspot

• Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Khedr, Waleed <FONT size=2>  INET: Waleed.Khedr_at_FMR.COM Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).
• Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com <FONT size=2>-- Author: Christopher Spence <FONT size=2>  INET: cspence_at_FuelSpot.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT size=2>-------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).