Thursday, September 6, 2012

Query To give Dba Object for specific User

Simple Topic let you know what is the database object for specific user

SELECT object_name, object_type
FROM   all_objects
WHERE  owner = 'SYS'
AND    object_type IN ('PACKAGE', 'PACKAGE BODY')
ORDER BY object_name, object_type;



Thank you
Osama Mustafa



No comments:

Post a Comment