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