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

[Christopher Spence]

Title: RE: TRUNCATE IN PL/SQL

Heh, you should have saw the post on LazyDBA. 

"Christopher is on the other list, and all he is doing is promoting his website, how annoying".

 

I got a kick out of that one.  Most of them I laugh off though.

 

"Walking on water and developing software from a specification are easy if both are frozen."

Christopher R. Spence
Oracle DBA
Fuelspot

-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 5:13 PM
To: Multiple recipients of list ORACLE-L
Subject: 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.

-----Original Message-----
From: Bowes, Chris [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 4:36 PM
To: Multiple recipients of list ORACLE-L
Subject: 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).