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 vote175 views1 answer
Insensitive case match sqlalchemy
SQL
18 votes177 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote177 views1 answer
MySQL update with subquery
SQL
0 vote169 views1 answer
Java spring boot connect to sql server
SQL
1 vote166 views1 answer
Mysql select another database
SQL
0 vote202 views2 answers
Greater than sql server
SQL
1 vote178 views1 answer
Oracle compile schema
SQL
3 votes221 views2 answers
Synonym oracle
SQL
1 vote173 views1 answer
Describe table in sql
SQL
6 votes164 views3 answers
Mysql first day of year
SQL