how to find common columns in two tables?

Question

Do i need to write in PL/SQL or is it possible in SQL query?

Answer 1

Query For Find Same Column from each Table.

select A.COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS A
join INFORMATION_SCHEMA.COLUMNS B
on A.COLUMN_NAME = B.COLUMN_NAME
where A.TABLE_NAME = 'Table_1'
and B.TABLE_NAME = 'Table_2'