sql oracle search column names code example

Example 1: sql search all columns of database oracle sql

select table_name from all_tab_columns where column_name = 'PICK_COLUMN';

DESCRIBE Table_Name;

OR 

DESC Table_Name;