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 vote243 views1 answer
Order by number of character in sql
SQL
1 vote160 views1 answer
Real world example of nosql
SQL
0 vote232 views1 answer
A network or instance-specific error sql server
SQL
1 vote190 views1 answer
Sql headers delphi
SQL
0 vote182 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote184 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
3 votes177 views3 answers
Postgresql random number
SQL
0 vote173 views1 answer
SQL column name Oracle
SQL
3 votes184 views3 answers
Mysql order by list
SQL
0 vote153 views2 answers
Postgresql display subquery as json
SQL