Database 11g

Tuesday, September 20, 2016

How to check Table Creation Date in Oracle



SQL> SELECT OWNER,OBJECT_NAME,CREATED FROM DBA_OBJECTS WHERE                                       OBJECT_NAME='PHTRNHST';

OWNER       OBJECT_NAME       CREATED
----------- ----------------- ------------------------------
PUBLIC          PHTRNHST             12-JAN-15



>> How to Check Table Names Which Starts from SHSH.


SQL> select table_name from all_tables where table_name like 'SHSH%';

TABLE_NAME
------------------------------
SHSHDTA_KK
SHSHTDTA
SHSHTDTA_BACKUP
SHSHTDTA_ORIGINAL
SHSHTDTA_PART
SHSHTDTL
SHSHTDTLLAST
SHSHTFLD
SHSHTGRP
SHSHTMRLIST
SHSHTNAM
SHSHTOLE
SHSHTPIC
SHSHTSNT
SHSHTDTL

15 rows selected.

Happy Learning....


No comments:

Post a Comment