SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select all tables with identical columns

682167May 26 2009 — edited May 26 2009

So practically i need a query that selects all the tables from a workspace with identical columns...
if this isnt possible then i have something like:
i have 3 tables, TABEL1, TABEL2, TABEL3 and with the next columns:

TABEL1
NRCRT NUME PREN CNP
TABEL2

NUMEELEV CNP
TABEL3

PRODUS PRET

i need a query that will look within these 3 tables and show me only the tables with the same column, in my example it will show:

TABEL1, and TABEL2

How do I do this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2009

Added on May 26 2009

11 comments

645 views