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

1 vote207 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote274 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote262 views1 answer
Python clean sql string
SQL
1 vote248 views2 answers
Pl sql case
SQL
0 vote278 views1 answer
Multiple replace value mssql
SQL
3 votes290 views2 answers
@sqlresultsetmapping
SQL
0 vote268 views1 answer
Sql case sttement with set
SQL
2 votes222 views1 answer
Oracle sql drop column if exists
SQL
0 vote272 views3 answers
Remove folders from remote git
SQL
0 vote259 views1 answer
Oracle db get table sizes
SQL