oracle - Query that shows 'BLOBs stored inline' -

i need produce query shows table(table_name, column_name) of blobs stored inline user_tables. appreciated.

to determine whether lob column stored in-line or out-of-line, need take @ in_row column value of user_lobs view (or [dba] [all] _lobs views depending on privileges granted): yes - inline, no - out-of-line:

for instance:

select t.table_name      , t.column_name      , t.in_row   user_lobs t table_name = 'blob_table' 

result:

table name   column name in row  -------------------------------- blob_table   col1        yes  blob_table   col2        yes  blob_table   col3        yes