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 vote150 views1 answer
Select last N rows mysql
SQL
0 vote145 views1 answer
Sql case when exists in another table
SQL
1 vote342 views2 answers
Coderbyte sql solutions
SQL
2 votes136 views1 answer
Sql update alias
SQL
1 vote99 views1 answer
Mssql string length
SQL
0 vote143 views1 answer
Drop constraint in ms sql
SQL
14 votes162 views4 answers
Online sql compiler
SQL
4 votes135 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
23 votes141 views6 answers
Delete all rows from table sql
SQL
0 vote150 views1 answer
Generate sequence number in sql server
SQL