lundi 8 février 2016

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

jeudi 4 février 2016