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 vote302 views1 answer
Insert into sql
SQL
0 vote349 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote403 views1 answer
Tsql cte in a transaction
SQL
0 vote332 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
3 votes339 views1 answer
Ssh check mysql version
SQL
4 votes365 views4 answers
What is primary key
SQL
1 vote394 views1 answer
Delete dublicate rows sql
SQL
1 vote409 views2 answers
Laravel jwt generate token
SQL
11 votes338 views2 answers
Oracle all source
SQL
1 vote333 views1 answer
Adding a default constraint to an existing column in sql
SQL