2 Replies Latest reply on May 7, 2014 2:53 PM by Riyashussain

    To get the Output of query as column delimited format

    Riyashussain

      Hi All,

       

      I am running below query to get information from database using an automation tool. The output of the query we are receiving is not coming with delimited value. Is there any way i can modify the query to get delimited output?

       

      Please provide your valuable inputs

       

      SELECT * FROM USER.DROP_DOWN_VALUE

      WHERE (SELEC_ID IN (SELECT ID FROM USER.DROP_DOWN WHERE FIELD_NAME = 'TABLE_NAME') )

      AND DEPENDENT_FIELD = 'XXXXXXX'


      Output of the query:


      43202TRANSFORMERTRANSFORMERXXXXXXX


      Expected Output:


      43202,TRANSFORMER,TRANSFORMER,XXXXXXX


      Thanks and Regards

      Riyas Hussain