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

0 vote307 views2 answers
Mysql insert rows to another database
SQL
1 vote179 views1 answer
Backup mysql data only
SQL
0 vote285 views1 answer
Multiple replace value mssql
SQL
1 vote253 views2 answers
Sql server find all foreign keys that reference a column
SQL
8 votes212 views4 answers
Reset SQL auto increment
SQL
0 vote174 views3 answers
Joins and views sql
SQL
0 vote180 views1 answer
Sql server set complex constraints
SQL
0 vote200 views1 answer
Drop index in sql
SQL
0 vote164 views1 answer
Mysql date + 1 day
SQL
6 votes180 views2 answers
If not exists insert sql
SQL