I tried using spool in sql statement ,it threw error.Lemme note down the real problem:I have a huge data sitting in three tables. Using data services , writing to file takes a long time, so I was advised to do it in sql level and add it as part of m...

I want to do this in a script like spool in oracle and put it as a part of my workflow. Hope this brings more clarity.Thanks!

Thank you for the response. I am looking for a way to do this as sql script through Data services. Like how we use spool.Thanks,Sangeeta

Thank you, I still have the same issue just for the first batch-id assignment. The rest is fine and working well..   Thank you, Sangeeta  

Hi Werner, Thank you for the swift response. I tried this solution. I used trunc + 1 as I wanted to get unique Id starting from 1, for eg first 20000 records will have batch id =1 ,the next 20000 will have 2 and so on. I also tried ( gen_row_num()...