Database Administration (MOSC)

MOSC Banner

How to match both the outputs?

edited Jun 28, 2011 5:40PM in Database Administration (MOSC) 3 commentsAnswered
How to match both the outputs?

SQL> select owner,table_name,substr(column_name,1,20) AS "Column", segment_name from dba_lobs where owner='AQ_MAIN' and table_name='AQ_MSG' ;

OWNER TABLE_NAME Column SEGMENT_NAME


AQ_MAIN AQ_MSG SYS_NC00010$ SYS_LOB0000120382C00010$$
AQ_MAIN AQ_MSG SYS_NC00012$ SYS_LOB0000120382C00012$$


SQL> select owner, table_name, column_id, column_name, data_type from dba_tab_columns where table_name='AQ_MSG' order by owner, table_name;

OWNER TABLE_NAME COLUMN_ID COLUMN_NAME COLUMN_TYPE


AQ_MAIN AQ_MSG 10 AQMSG_XML_PAYLOAD XMLTYPE

AQ_MAIN AQ_MSG 9 AQMSG_XML_MESSAGE XMLTYPE 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center