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 vote209 views1 answer
ORACLE PARSE STRING
SQL
0 vote202 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote208 views1 answer
Create dump file mysql workbench
SQL
1 vote210 views1 answer
Events mysql
SQL
8 votes213 views1 answer
Sql remove leading spaces
SQL
2 votes190 views2 answers
Mysql get time from datetime
SQL
0 vote208 views1 answer
Sqlcl format
SQL
1 vote206 views1 answer
Order by oracle
SQL
0 vote229 views2 answers
Coursera spark sql max count
SQL
0 vote202 views1 answer
Pgadmin see indexes
SQL