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 vote204 views1 answer
Mysql history command
SQL
1 vote213 views1 answer
Operator does not exist: integer = text
SQL
1 vote201 views1 answer
Postgresql convert text to float
SQL
0 vote219 views1 answer
Mysql docker image arjun
SQL
8 votes227 views2 answers
Sqlsrv default port
SQL
1 vote222 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote202 views1 answer
Dasebase_url-postgres for windows
SQL
1 vote227 views1 answer
How to delete data from sql database in android
SQL
0 vote215 views1 answer
Mysql_error replacement
SQL
1 vote237 views1 answer
Set id count mysql
SQL