Skip to content

Oracle

Data Dictionary Storage

Views: User_Objects, User_source, User_Errors, User_Object_size, User_Dependicies –Query the User_Objects view for all procedures and functionsSELECT object_name, statusFROM user_objectsWHERE object_type IN(‘PROCEDURE’, ‘FUNCTION’); —Determine which objects have… Read More »Data Dictionary Storage

Exit mobile version