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

0 vote164 views1 answer
Prisma transaction
SQL
0 vote150 views2 answers
Sql stored procedure for access frontend
SQL
0 vote123 views1 answer
Check if a word appears at the end sql query
SQL
2 votes150 views1 answer
Mysql select true or false
SQL
0 vote132 views1 answer
Data structures in sql
SQL
0 vote138 views1 answer
Get initial in sql
SQL
0 vote125 views1 answer
Sql get date from timestamp
SQL
0 vote135 views1 answer
Describe in sqlite3
SQL
0 vote139 views1 answer
Retornar apenas o ano mysql date
SQL
1 vote147 views1 answer
Ubuntu access database from terminal
SQL