Compare list in PL/SQL - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Compare list in PL/SQL

MeldrozMeldroz Posts: 38Member
Hi all,
I'm a java programmer but currently have a task to compare different list and output their common element in PL/SQL. In java this is very simple but i'm not sure how i would handle this in sql since i'm fairly new to it.

ex
l1='A,B,C,D'
l2='B,C,D'
l3 ='A'

l1+l2 = (B,C,D)

l1+l3 = (A)

l2+l3 = 0

Has anyone ever done anything similar in sql? Would really appreciate any help on this.

Comments

Sign In or Register to comment.