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 vote337 views1 answer
Pl sql disable trigger
SQL
16 votes292 views4 answers
Mysql import from sql file
SQL
0 vote313 views1 answer
Find how many tables in database sql query
SQL
0 vote319 views1 answer
Compare subqueries oracle
SQL
3 votes308 views1 answer
Oracle failed login attempts
SQL
1 vote319 views1 answer
Sql server insert into temp table
SQL
0 vote302 views1 answer
Merge clause with inner join
SQL
0 vote326 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote302 views1 answer
Sql server sleep
SQL
1 vote287 views1 answer
Psql connect to another database
SQL