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

13 votes134 views2 answers
Sql join
SQL
12 votes180 views2 answers
Update column data type postgres
SQL
0 vote127 views1 answer
Like date sql server not working
SQL
0 vote86 views1 answer
Postgres delete where id in
SQL
1 vote125 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote145 views1 answer
Declaring variables in pl sql
SQL
2 votes126 views1 answer
Update trigger
SQL
3 votes86 views1 answer
Ubuntu install postgresql 12
SQL
1 vote132 views3 answers
Reset sql primary key
SQL
0 vote143 views1 answer
Mysql order by where condition sub query
SQL