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 vote292 views2 answers
How to create a table from another table in sql derby
SQL
0 vote288 views1 answer
SQL SELECT-Klausel
SQL
1 vote284 views2 answers
T sql get foreign key
SQL
3 votes286 views2 answers
Brew start mysql
SQL
0 vote245 views1 answer
Delete all rows from table sqlite
SQL
0 vote279 views1 answer
Sql insert tuple
SQL
4 votes295 views1 answer
Oracle error line
SQL
1 vote277 views1 answer
Mysql pretty date format
SQL
24 votes277 views4 answers
How to add column sql
SQL
0 vote282 views2 answers
Sql use not in
SQL