Yesterday a friend came across an oracle query problem: Consider below table: cid cname…. cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the…