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 vote147 views1 answer
Postgresql show owner of database
SQL
0 vote134 views3 answers
Database restoring error
SQL
14 votes128 views1 answer
Excel
SQL
27 votes128 views5 answers
Add column in table
SQL
5 votes123 views2 answers
Oracle to_timestamp
SQL
1 vote150 views1 answer
Nvl postgres
SQL
3 votes132 views1 answer
Oracle transaction commit rollback example
SQL
0 vote80 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote137 views1 answer
Create table split string function in sql server
SQL
0 vote119 views1 answer
How to define a save method in ruby for sql databases
SQL