Skip to Main Content
Forums

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!

How to find column data is equal or not equal, in single table two different records?

user13130497Jun 9 2016 — edited Jun 9 2016

Hi All,

I have table it contains more than 500 columns but here is the sample data.

pastedImage_0.jpg

Case 1:

I have an input of two task_event_ids i.e.,16654913, 16654915 and COL2.

Here I need to find out COL2 data is equal or not for both records. here COL2 data is not equal.

Case 2:

I have an input of two task_event_ids i.e.,16654913, 16654915 and COL3.

Here I need to find out COL3 data is equal or not for both records. here COL3 data is equal.

Here I need to make the generic query, to find content of the COLUMN (i.e. Column name is dynamic it will be one of 500 columns in my table) is equal or not in both records.

Appreciate your help on this.

Thanks,

-Venkat.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2016
Added on Jun 9 2016
7 comments
1,255 views