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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL !

Re: PL/SQL !

From: peter <staff_at_searchwho.com>
Date: Mon, 20 Aug 2001 22:15:36 GMT
Message-ID: <c_fg7.755$ZN5.121150@newsread1.prod.itd.earthlink.net>


You could always write a function to return a true/false based on whether the tablename is or is not found in the data dictionary "user_tables" view.

-peter

Rahul wrote in message <923a99a4.0108201211.f59a523_at_posting.google.com>...
>hi there:
>
>I was wondering if you have the answer of following two questions:
>
>a. 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 - 17:15:36 CDT

Original text of this message

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