If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Thanks Shestakov. In that example you gave (in the inner decode function )can we use a field_name instead of users.Users is just a string you gave but I want to display a column value there instead some other value.

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