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 vote364 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
-1 vote354 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote357 views1 answer
Mysql sql select one day before
SQL
0 vote319 views1 answer
Java spring boot connect to sql server
SQL
0 vote363 views1 answer
Mysql grouping functions
SQL
4 votes363 views1 answer
Search column by name mysql
SQL
12 votes358 views4 answers
Mysql version
SQL
3 votes336 views1 answer
Index using in query plsql
SQL
0 vote398 views1 answer
Date 3 months from today sql
SQL
4 votes372 views1 answer
Alter session set nls_date_format
SQL