Re: How to know if a procedure exists?

I usually use something like this:

  1 select *
  2 from all_objects
  3 where object_name like '%TIME%'
  4* and object_type = 'PROCEDURE'

Jacques Sireude wrote:

> Hi,
> What is the sql statement to know if a procedure does exists in the
> database?
Received on Tue Jul 07 1998 - 09:50:19 CDT