SELECT T.TABLE_NAME,T.COMMENTS,C.TABLE_NAME,C.COLUMN_NAME,C.COMMENTS FROM (select * from all_tab_comments where OWNER = 'USER') T
LEFT JOIN
(select * from all_col_comments where OWNER = 'USER') C
ON T.TABLE_NAME=C.TABLE_NAME
ORDER BY T.TABLE_NAME
LEFT JOIN
(select * from all_col_comments where OWNER = 'USER') C
ON T.TABLE_NAME=C.TABLE_NAME
ORDER BY T.TABLE_NAME