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 vote103 views1 answer
Athena query timestamp greater than
SQL
0 vote154 views1 answer
Traccar mysql
SQL
0 vote154 views1 answer
Open postgresql.conf in centos
SQL
2 votes146 views1 answer
Oracle current date without time
SQL
0 vote171 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
2 votes143 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote150 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote158 views1 answer
Sql find table by name
SQL
0 vote147 views1 answer
Create synonym for dblink in oracle
SQL
0 vote161 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL