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