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 vote200 views1 answer
Sql get user account
SQL
4 votes203 views1 answer
Wildcard in sql
SQL
1 vote205 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote204 views1 answer
Mysql root permission denied lost
SQL
0 vote200 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote218 views3 answers
Postgres date difference seconds
SQL
0 vote194 views1 answer
Mysql default timestamp value to be current timestamp
SQL
0 vote216 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote299 views1 answer
Mysql collation portugues brasil
SQL
2 votes209 views3 answers
Replace null in sql
SQL