all_objects « System Tables Views « Oracle PL / SQL






1.query all_objects table and subtract object_name
2.ALL_OBJECTS view combines all types of Oracle structures into one view.