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 vote306 views1 answer
Postrgres trunc
SQL
9 votes295 views3 answers
Show table columns mysql command line
SQL
3 votes283 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
1 vote292 views2 answers
Postgresql get difference in hours between two dates
SQL
2 votes249 views1 answer
Mysql admin u root p password change password
SQL
0 vote277 views1 answer
Postgres truncate with cascade
SQL
5 votes342 views2 answers
How to ascending order in sql
SQL
1 vote287 views1 answer
Psql lst trigger
SQL
26 votes287 views6 answers
Modify column name in sql
SQL
0 vote291 views1 answer
Oracle service name view
SQL