How do I prepare the packages in oracle?

Navigation
1

How do I make a query (PL / SQL) to list a specific Package in the database (Oracle)?

    
asked by anonymous 07.11.2016 / 14:08

1 answer

2

To list all packages: 

SELECT   object_name
FROM     user_objects
WHERE    object_type = 'PACKAGE';

To check if a specific package exists: 

SELECT   object_name
FROM     user_objects
WHERE    object_type = 'PACKAGE'
    AND  object_name = 'NomeDoPackage'
    
07.11.2016 / 14:47
Show or Hide modal with sessionStorage Very large select box content