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
Vbscript create ADODB.Connection
SQL
0 vote128 views1 answer
How to set sql_mode for a query in CI model
SQL
1 vote116 views1 answer
How to see which columns are indexxed mysql
SQL
1 vote113 views1 answer
Oracle grant on all tables in schema
SQL
0 vote118 views8 answers
Convert sql query to linq online
SQL
0 vote124 views1 answer
Tsql table column constraint must be uppercase
SQL
1 vote111 views1 answer
Select 2 rows in sql
SQL
0 vote119 views1 answer
Closure in sql
SQL
4 votes136 views2 answers
Float postgres
SQL
0 vote134 views1 answer
Sql basic commands
SQL