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 vote375 views1 answer
MySQL - Enabling the Event Scheduler
SQL
10 votes315 views2 answers
Mysql select timestamp group by day
SQL
0 vote304 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote315 views1 answer
Recursive query herarchical data sql server
SQL
9 votes332 views2 answers
Sql limit order by
SQL
0 vote339 views1 answer
Sql get month and year from date
SQL
1 vote346 views2 answers
Sql for date greater than
SQL
0 vote355 views1 answer
Mysql drop trigger
SQL
22 votes324 views2 answers
Mysql show all tables
SQL
0 vote346 views1 answer
C# mysql update statement set value to null
SQL