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;