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

1 vote383 views4 answers
How to check table in postgresql from terminal
SQL
0 vote392 views1 answer
Delete ids between sql
SQL
0 vote375 views1 answer
What is metadata in sql
SQL
0 vote314 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
1 vote322 views1 answer
Increase existing date in sql oracle
SQL
0 vote329 views1 answer
Install sql server in ubuntu 20.04
SQL
5 votes348 views1 answer
Sql add column after another
SQL
0 vote336 views1 answer
Oracle date winter time
SQL
0 vote329 views1 answer
QUERY JPQL
SQL
0 vote317 views1 answer
Mariadb maximum left join
SQL