Had a strange issue with Oracle SQL Developer whereby it wasn’t showing a data object which I knew existed and realised I didn’t know the SQL to find it – sure SQL Developer does it all in the GUI but it’s nice to know how to do it in code, so here goes

select * from ALL_OBJECTS where OBJECT_NAME = 'SomeTableViewProcOrWhatever'