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 vote357 views1 answer
List all triggers in SQL Server
SQL
-2 votes355 views1 answer
Mysql see users and passwords
SQL
0 vote363 views1 answer
Every Derived yable must have its own alias
SQL
0 vote350 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote336 views1 answer
Postgresql create user roles
SQL
0 vote351 views1 answer
Sql server sleep
SQL
22 votes384 views3 answers
Year format in date mysql
SQL
0 vote356 views1 answer
Sql server convert to guid
SQL
0 vote389 views1 answer
Trigger vérifier stock
SQL
18 votes353 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL