Oracle User Objects Viewer
Displays all database objects owned by the current user, including object name and type. Useful for quick schema inspection and object inventory.
oraclesqlreporting-analyticsv1.0.0
0 stars0 downloads16 views0 comments
By OracleDba • Created
Code
(14 lines)1234567891011121314
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/monitoring/user_objects.sql
-- Author : Tim Hall
-- Description : Displays the objects owned by the current user.
-- Requirements :
-- Call Syntax : @user_objects
-- Last Modified: 23-OCT-2019
-- -----------------------------------------------------------------------------------
COLUMN object_name FORMAT A30
SELECT object_name, object_type
FROM user_objects
ORDER BY 1, 2;