How to search a column name within all tables of a database

Question

I'M TRYING to find a column called author_last_name in oracle-apex I want to find a column in my schema is it possible to search for a column or do i have to look through every table? i have at least 50 tables in my schema
select table_name,column_name from cihe.columns where column_name like '%author%'

Answer 1

select table_name, column_name
from user_tab_columns
where column_name like '%AUTHOR%';

All system views are documented here: http://docs.oracle.com/cd/E11882_01/server.112/e25513/toc.htm