3 Replies Latest reply on Dec 5, 2017 4:44 AM by mNem

    dynamic spooling of data by comma separated with double quotes

    KK23

      Hi All,

       

      we have a requirement , we need to spool a table data by comma and double quotes separeted.. those output of data needs to load via sqlloader.

       

      Output:

       

      "01","ADFSAFS","9883"

      "02","SAFSAFD","83084"

      "03","IJSDFSFSA","98083"

       

      Requirement :

       

      if i pass the table name need to spool all column data in above format .

       

      dynamic passing of table name.

       

      Thanks in advance.