From MohanR@STARS-SMI.com Thu, 21 Jun 2001 13:18:08 -0700 From: "Mohan, Ross" Date: Thu, 21 Jun 2001 13:18:08 -0700 Subject: OT RE: TRUNCATE IN PL/SQL ( a.k.a The Thread that Will Not Die ) Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: TRUNCATE IN PL/SQL I personally notice a bunch of peole giving Chris their two cents on a fairly frequent basis. -----Original Message-----From: Bowes, Chris [mailto:Chris.Bowes@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: http://www.orafaq.com -- Author: Khedr, Waleed   INET: Waleed.Khedr@FMR.COM Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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: http://www.orafaq.com -- Author: Christopher Spence   INET: cspence@FuelSpot.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).