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 vote94 views1 answer
Php delete database
SQL
2 votes121 views3 answers
Sql interview query questions
SQL
0 vote108 views2 answers
Sql query for getting details by id
SQL
1 vote96 views1 answer
Set id count mysql
SQL
0 vote102 views1 answer
Grant privileges of databse to user
SQL
15 votes98 views4 answers
Create table if not exists sql
SQL
0 vote52 views1 answer
Ms sql unique
SQL
0 vote87 views1 answer
Sql new line output
SQL
0 vote104 views2 answers
Generate sql trigger through ef migration
SQL
0 vote98 views1 answer
Sql select all tables from database change url
SQL