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 vote225 views1 answer
Compress sql file database ubuntu
SQL
0 vote210 views1 answer
Sql missing values
SQL
1 vote206 views1 answer
Epoch time converter in snowflake
SQL
1 vote201 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote207 views1 answer
How to run mysql on terminal mac
SQL
0 vote198 views1 answer
Pl sql round
SQL
0 vote201 views1 answer
Postgres data location
SQL
0 vote216 views1 answer
New rails app with mysql
SQL
3 votes179 views1 answer
Sql replace character in string in all records
SQL
0 vote209 views1 answer
Sql alter table add column if exists
SQL