Member Avatar for Meldroz
Meldroz 0 Newbie Poster

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.

  • 1 Contributor
  • 0 Replies
  • 62 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.