SELECT table_name, column_name, comments FROM all_col_comments WHERE owner = 'LLV3'--Schema name AND (table_name LIKE '%recipe%' OR column_name LIKE '%recipe%' OR comments LIKE '%recipe%') OR (table_name LIKE '%element%' OR column_name LIKE '%element%' OR comments LIKE '%element%') OR (table_name LIKE '%RCP%' OR column_name LIKE '%RCP%' OR comments LIKE '%RCP%') ORDER BY table_name, column_name; --How to know your SCHEMA SELECT sys_context('USERENV', 'CURRENT_SCHEMA') as schema_name FROM dual;