Quick Oracle tips v2 (2016)

Here a quick list of queries that may help you to gain sometime while checking for objects


1.  Getting the objects of the database:


Select  *  from DBA_OBJECTS where object_type like 'TABLE' AND owner like '%CAD'




2.  Setting the format for date types in oracle sql developer

Go to Tools> Preferences > Database > NLS and set the Date Format as MM/DD/YYYY HH24:MI:SS