Check table info
SQL> desc employees
or
SQL>
select * from all_tab_columns where lower(table_name) = 'employees'
Find column name
e.g.
Current user scope:
SQL>
select * from all_tab_columns where lower(column_name) = 'employee_id'
DBA user scope:
SQL>
select * from dba_tab_columns where lower(column_name) = 'employee_id'
SQL> desc employees
or
SQL>
select * from all_tab_columns where lower(table_name) = 'employees'
Find column name
e.g.
Current user scope:
SQL>
select * from all_tab_columns where lower(column_name) = 'employee_id'
DBA user scope:
SQL>
select * from dba_tab_columns where lower(column_name) = 'employee_id'