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

2 votes216 views1 answer
Sql find missing values between two tables
SQL
22 votes260 views4 answers
Date format mysql
SQL
2 votes251 views1 answer
Oracle sql merge
SQL
3 votes244 views1 answer
Oracle show trigger code
SQL
3 votes245 views3 answers
Mysql order by list
SQL
-1 vote223 views1 answer
Sql syntax create timestamp column
SQL
21 votes252 views1 answer
Cheatsheet for sql
SQL
2 votes250 views1 answer
Where clause for child record apex
SQL
0 vote239 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote200 views1 answer
Unique vs distinct sql
SQL