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 vote226 views1 answer
Interview experience as a call?
SQL
0 vote221 views1 answer
Horizontal join sqlite
SQL
0 vote227 views1 answer
Oracle service name view
SQL
5 votes212 views1 answer
Mysql get last day of month
SQL
0 vote252 views1 answer
SQL-Arten
SQL
0 vote215 views1 answer
Get duplicate entry sql
SQL
0 vote238 views1 answer
Sql select where more than one record exists
SQL
0 vote212 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote230 views1 answer
Postgresql alter column nullable
SQL
0 vote252 views1 answer
Make parameters nullable in sql server
SQL