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 vote138 views1 answer
Update sql join multiple tables
SQL
3 votes249 views1 answer
Mysql group_concat distinct
SQL
10 votes173 views1 answer
Oracle dependency
SQL
22 votes183 views4 answers
Mysql reset auto increment id
SQL
4 votes179 views2 answers
Oracle last day of month
SQL
0 vote186 views1 answer
How to create a table based on another table in mysql
SQL
0 vote186 views1 answer
Mysql where in keep order
SQL
8 votes184 views1 answer
Oracle create datafile
SQL
0 vote217 views1 answer
What is logical database schema
SQL
8 votes191 views1 answer
How to check mysql version in xampp
SQL