0
SELECT DLV_TO FROM CDH_SLA_CFG WHERE COD_CAO_PAX='C' AND FLT_CAR='CX';

Query output:

   DLV_TO
 -----------
 1 SEO,BULK

Expecting output:

    DLV_TO
 -----------
 1 SEO
 2 BULK

How to achieve it?

Santosh Jadi
  • 1,401
  • 6
  • 28
  • 52
  • 2
    Never ever store data as comma separated items. It will only cause you lots of trouble. – jarlh Feb 13 '18 at 10:41
  • 1
    There appear to be a number of good methods for handling this already out there. Try a query, and if you get stuck, then update this question and someone can un-dupe it. – Tim Biegeleisen Feb 13 '18 at 10:43

0 Answers0