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.
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.