Sql common columns

-- NB: Applicable for Oracle and PL/SQL only

select * 
from all_tab_cols A
where 
   A.COLUMN_NAME in 
   (
      select B.column_name
      from all_tab_cols B
      where B.table_name = 'YourFirstTable'
   )
   and A.table_name != 'YourFirstTable'
   and A.TABLE_NAME = 'YourSecondTable';

Similar codes

9 votes333 views3 answers
Show table columns mysql command line
SQL
3 votes358 views5 answers
Duplicate table sql
SQL
0 vote323 views1 answer
Compare if is null sql
SQL
5 votes327 views2 answers
Copy data from one database to another
SQL
0 vote325 views2 answers
How to list all values of a column that start with a letter in sql
SQL
10 votes357 views1 answer
Oracle view dependencies
SQL
6 votes320 views2 answers
Mysql check auto increment value
SQL
0 vote357 views1 answer
ORA-13717
SQL
2 votes325 views1 answer
Oracle number to percentage
SQL
6 votes341 views3 answers
Update with inner join postgres
SQL