Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Is there any way to compare index by columns and column orders in oracle?

1028309Jul 25 2013 — edited Jul 26 2013

create table student_A(      

id number not null,

name varchar2(50),

lastname varchar2(50));

                               

create unique index intstd_A on student  (id);

create table student_B(      

id number not null,

name varchar2(50),

lastname varchar2(50));

                               

create unique index intstd_A on student_B (id , lastname );

What would be the query to compare this two?

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 23 2013
Added on Jul 25 2013
9 comments
866 views