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

47 votes188 views6 answers
Add column mysql
SQL
16 votes122 views3 answers
Jwt secret key generator laravel
SQL
6 votes122 views2 answers
Foreign key sqlite3 python
SQL
0 vote160 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote130 views1 answer
Convert multiple columns to ROws in sql server
SQL
7 votes132 views2 answers
Create mysql user
SQL
0 vote171 views1 answer
Sql delete row from table where id
SQL
7 votes115 views1 answer
Mysql remote connection command line
SQL
38 votes172 views6 answers
Alter table mysql
SQL
4 votes113 views6 answers
Sql select statement
SQL