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

3 votes165 views1 answer
Select database in sql
SQL
0 vote155 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote164 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote144 views1 answer
Oracle rolling back
SQL
6 votes246 views1 answer
Sql insert values into table
SQL
0 vote164 views1 answer
Select distinct after join
SQL
0 vote169 views1 answer
Postgre query date
SQL
0 vote151 views2 answers
Postgres default user
SQL
0 vote168 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote185 views2 answers
Copy table in sql
SQL