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 vote277 views1 answer
Connecting mySQL to STS
SQL
0 vote296 views1 answer
Select place default lat long
SQL
0 vote250 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote267 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
1 vote237 views1 answer
Database run
SQL
16 votes267 views4 answers
Sort by sql
SQL
-1 vote296 views1 answer
Get month and year from date in mysql sequelize
SQL
4 votes272 views2 answers
Postgre sql create table
SQL
2 votes278 views1 answer
Set username and password for postgresql database
SQL
7 votes299 views2 answers
Mysql check db size
SQL