|
-
u can just little bit modify this example:
in this example i used :
-- internal decode and
-- choice from different dields in decode
I hope this is enough.
select object_name,
decode(object_type,
'TABLE', 'This is table of schema :'|| decode(owner,'SYS','SYS DBA',owner),
'INDEX', 'This index created : '||to_char(created),
object_type)
from all_objects
;
AQ$_MESSAGE_TYPES This is table of schema :SYS DBA
AQ$_MSGTYPES_PRIMARY This index created : 16-APR-01
AQ$_NOTIFY_MSG TYPE
AQ$_PENDING_MESSAGES This is table of schema :SYS DBA
AQ$_PROPAGATION_SEQUENCE SEQUENCE
AQ$_PROPAGATION_STATUS This is table of schema :SYS DBA
AQ$_PROPAGATION_STATUS_PRIMARY This index created : 16-APR-01
AQ$_QTABLE_AFFINITIES_PK This index created : 16-APR-01
AQ$_QUEUE_STATISTICS This is table of schema :SYS DBA
AQ$_QUEUE_STATITICS_PK This index created : 16-APR-01
AQ$_QUEUE_TABLE_AFFINITIES This is table of schema :SYS DBA
AQ$_RECIPIENTS TYPE
AQ$_SCHEDULES This is table of schema :SYS DBA
AQ$_SCHEDULES_PRIMARY This index created : 16-APR-01
AQ$_SUBSCRIBERS TYPE
ARGUMENT$ This is table of schema :SYS DBA
ASSOC1 This index created : 16-APR-01
ASSOC2 This index created : 16-APR-01
ASSOCIATION$ This is table of schema :SYS DBA
ATEMPIND$ This index created : 16-APR-01
ATEMPTAB$ This is table of schema :SYS DBA
ATTRCOL$ This is table of schema :SYS DBA
AQ$_QUEUES_CHECK This index created : 16-APR-01
AQ$_QUEUES_PRIMARY This index created : 16-APR-01
AQ$_QUEUE_TABLES This is table of schema :SYSTEM
AQ$_QUEUE_TABLES_PRIMARY This index created : 16-APR-01
AQ$_SCHEDULES This is table of schema :SYSTEM
AQ$_SCHEDULES_CHECK This index created : 16-APR-01
AQ$_SCHEDULES_PRIMARY This index created : 16-APR-01
CATALOG SYNONYM
CHECK_CONST FUNCTION
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|