Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> PL/SQL !

PL/SQL !

From: Rahul <rahul_europe_at_yahoo.com>
Date: 20 Aug 2001 13:11:27 -0700
Message-ID: <923a99a4.0108201211.f59a523@posting.google.com>


hi there:

I was wondering if you have the answer of following two questions:

  1. Inside PL/SQL block, how to check that a particular table does not exist.

I know this one,but there will be some other better ways as well, so do you know some of them?

if(rad_cursor2%NOTFOUND) then

   dbms_output.put_line('the table is emply');

b. how to call a trigger block from PL/SQL block.

regards,
rahul Received on Mon Aug 20 2001 - 15:11:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US