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 vote221 views1 answer
Mysql récupérer le code création de vue
SQL
1 vote196 views2 answers
Pl sql case
SQL
0 vote189 views1 answer
Sqlite select split string
SQL
0 vote209 views1 answer
USING THE NOT CONDITION IN SQL
SQL
9 votes216 views4 answers
Last mysql
SQL
0 vote189 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
19 votes204 views6 answers
Sql create table
SQL
0 vote185 views1 answer
Top frequency in sql server
SQL
2 votes137 views1 answer
Mysql admin u root p password change password
SQL
2 votes241 views1 answer
Match in sql server
SQL