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 vote164 views1 answer
Round function in sql oracle
SQL
0 vote260 views1 answer
Mysql select random rows large table
SQL
3 votes197 views5 answers
No module named 'MySQLdb'
SQL
4 votes182 views1 answer
Adding data to table in sql python
SQL
17 votes171 views6 answers
Current date in sql
SQL
0 vote168 views1 answer
Nth max in my sql
SQL
11 votes192 views1 answer
How to get ddl for materialized view
SQL
8 votes179 views1 answer
Oracle all_source package body
SQL
6 votes189 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
-1 vote180 views2 answers
Mysql get day of week
SQL