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

5 votes189 views2 answers
Mysqldump password
SQL
0 vote203 views1 answer
Postgres - Login and connect as default user
SQL
0 vote177 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote177 views1 answer
Mysql make date from 2 column
SQL
0 vote194 views1 answer
How to know if table in rigt or left in sql
SQL
10 votes159 views2 answers
Mysql select timestamp group by day
SQL
0 vote179 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
6 votes162 views4 answers
Sqlite drop table
SQL
9 votes168 views4 answers
Add primary key to existing table sql
SQL
3 votes181 views2 answers
How to start mysql in terminal
SQL