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 vote170 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote141 views2 answers
List all constraints in postgres
SQL
0 vote136 views1 answer
Add column in sql server ubuntu
SQL
2 votes147 views1 answer
Sql server check for value in multiple columns
SQL
0 vote133 views1 answer
Fill up postgres db
SQL
0 vote172 views1 answer
SQL check if record exist
SQL
0 vote212 views1 answer
Sql if clause within where clause
SQL
0 vote93 views0 answer
SQL
17 votes143 views4 answers
Postgres list users
SQL
1 vote159 views1 answer
Sql order by timestamp
SQL