2 Replies Latest reply: Oct 24, 2012 2:35 PM by Celambarasan Adhimulam RSS

    Table fields and Variables

      In the load script, is it possible to use a field in a table after it has been created? Can I use that I field and assign it to a variable using LET?

      I think this would be better presented through an example...



      SELECT tr_product,


          tr_date as "cal_date"

      FROM transactions;


      LET vTDate = cal_date;                 


      --- after this some other load stuff follows ---


      I hope you get my problem. If there is a solution to this, could you please show me? 

      Appreciate your help!