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

6 votes189 views1 answer
Postgresql get year
SQL
0 vote212 views1 answer
Check constraint is violated
SQL
2 votes196 views1 answer
Sql percentage with % rounded down
SQL
1 vote179 views1 answer
Sql update table remove spaces
SQL
0 vote186 views1 answer
Download mysql database to excel in android studio
SQL
0 vote186 views4 answers
Mysql replace regex
SQL
0 vote212 views2 answers
Mysql show foreign keys
SQL
0 vote182 views1 answer
What alter does in db
SQL
0 vote208 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
10 votes202 views4 answers
Join with multiple conditions sql
SQL