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 vote101 views1 answer
Postgresql like
SQL
8 votes116 views2 answers
Grant all privileges database postgres to user
SQL
0 vote111 views1 answer
Oracle date winter time
SQL
0 vote98 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote102 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote108 views1 answer
Dump db only triggers mysql
SQL
13 votes108 views2 answers
Sqlite rename table
SQL
0 vote131 views1 answer
Postgres full text search example
SQL
7 votes106 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
6 votes155 views2 answers
How to get last element sql
SQL