2/28/2023 0 Comments Lxfree exporting a group![]() ![]() Now I want the rows to be inserted into table sail_abcd, 250 rows at a time. But then my exported excel will contain rownum column also which I don't need.)To make it more test approachable, Suppose, my table sail_abc has 999 rows. I can do that by adding rownum pseudocolumn into a column of my query and breaking the data based on this. So I need to call this package two times. However, if the count of rows of my table is more than certain number, say 1 million, it has to break the data into two files and send them. (In the real scenario, I have a package that runs my query, creates excel and pushes it into a destination folder. Thank you.Can you also throw some light on how to split the data into four files. ![]() $a!| wrote:Hi Solomon,This is new to me and helpful. Please let me know if need more explanation. Sorry if the above description is confusing. V_insert_str := 'insert into sail_abcd ' ||v_str || ' where r between '||rn_min ||' and '|| rn_max īut as mentioned above, rownum became a permanent column in the destination. Select count(*) into v_count from sail_Abc V_str varchar2(1000):= 'select * from (Select a.*,rownum r from sail_abc a) ' To make it more test approachable, Suppose, my table sail_abc has 999 rows. But then my exported excel will contain rownum column also which I don't need.) Thank you.Ĭan you also throw some light on how to split the data into four files. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |