Niti

• May 3rd, 2006

 

Use the query Select object_name,object_type from all_objects where owner = 'username';

Kala

• May 4th, 2006

 

Use the below query

select object_name, object_type from user_objects

where object_type in ('PACKAGE','PROCEDURE','FUNCTION','TRIGGER')

Sphurti

• Aug 14th, 2006

 

Basically, here USER_OBJECTS will have all the objects which are created/own by a particular user whereas ALL_OBJECTS will have information of the objects for which a user has access, it may or may not be created by that user.

g_sidhu

 Profile 

• Feb 1st, 2008

 

SELECT object_name, object_type

FROM user_objects

WHERE object_type in ('PROCEDURE','FUNCTION')

ORDER BY object_name;