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 vote136 views1 answer
Sql gather statistics to increase performance
SQL
0 vote125 views1 answer
Lister les index d'une table oracle
SQL
0 vote132 views2 answers
How do I install microsoft SQL on my Mac?
SQL
1 vote141 views1 answer
Oracle lowercase
SQL
9 votes171 views3 answers
Date format in sql
SQL
25 votes157 views5 answers
Uninstall mysql ubuntu
SQL
6 votes142 views1 answer
What is where clause in sql
SQL
0 vote141 views1 answer
Procedure excute monthly oracle
SQL
4 votes137 views2 answers
Sql server date now
SQL
5 votes128 views2 answers
Create table
SQL