I'm not sure if you getting column and data confused here. Are you looking for column names that contain 'TOTO' or data within the table/column that contains 'TOTO'? If you are looking for the data, you can use the all_tab_columns Oracle table in a cursor to get all columns in all tables and...
select *
from all_tab_columns
where column_name like '%TOTO%'
You may want to eliminate SYS and SYSTEM as owners in the query unless you are intersted in Oracle system tables.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.