DBA_LOBS describes all LOBs in the database.
select table_name || '.' || column_name table_column, segment_name lob_name, in_row from dba_lobs where rownum <20