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 vote147 views1 answer
Comma seperated join mssql
SQL
1 vote154 views1 answer
How to put value in variable mysql
SQL
0 vote156 views1 answer
Microsoft sql server python connection
SQL
6 votes132 views5 answers
Alter table oracle
SQL
2 votes146 views3 answers
Sql truncate table
SQL
11 votes153 views5 answers
Sql server reset identity
SQL
1 vote147 views1 answer
Oracle sql first day of year
SQL
0 vote141 views3 answers
Mysql delete if not in another table
SQL
0 vote150 views1 answer
Primary key multiple
SQL
0 vote239 views1 answer
Insensitive case match sqlalchemy
SQL