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!

How can i compare two XML files storeds in a LONG column

509198Oct 4 2012 — edited Oct 5 2012
Hi,

I need to compare two xml files. My xmls are stored in two table like this:

Table 1
ID_COL number(5);
XML1 LONG()

Table 2
ID_COL number(5);
XML2 LONG()

I need compare the values of the tags of this xmls files e to list de differences.

Tks,
Fernando.

Comments

Scott Wesley
Answer

The native Popup Lov facilitates multi-value selection (from 19.x), or the Select2 plugin can do the same. This would be from a known set of values.
They will store the values in a delimited string for that field, which you than then use apex_string.split to break it up as necessary.
If you need to dynamically add tags, then you may consider the United Codes List Extension plugin

Marked as Answer by SteveQuinlivan · Apr 21 2021
SteveQuinlivan

Thanks @scott-wesley, the Popup Lov will give me what i need

Regards

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2012
Added on Oct 4 2012
10 comments
514 views