OraFAQ Forum: SQL & PL/SQL » How to Split the Records

Home » SQL & PL/SQL » SQL & PL/SQL » How to Split the Records (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Split the Records [message #639898]

Mon, 20 July 2015 04:44

rahulsf
Messages: 3
Registered: March 2015
Location: Pune

Junior Member

what i am doing is that,
suppose if i have 15 records i want to split it into 3 parts.
ex :- if records = 15
then 15/5 = 3 group of data.
like first 5 records set
then second 5 records set
then third 5 records set.

please help me

Thanks in Advance...

Report message to a moderator

Re: How to Split the Records [message #639899 is a reply to message #639898]

Mon, 20 July 2015 04:46

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

How would you tell where one set stops and another set starts?

Report message to a moderator

Re: How to Split the Records [message #639903 is a reply to message #639899]

Mon, 20 July 2015 04:52

rahulsf
Messages: 3
Registered: March 2015
Location: Pune

Junior Member

Actually the thing is that i have to create an outbound interface.

there is one sql which will get the data and it will write into a file
using UTL file package.

data is fetching properly and writing in a file.
but the data is so big,
i want to write the data into multiple file.
like set of 10000,10000,10000 (if records are 30000).

Report message to a moderator

Re: How to Split the Records [message #639904 is a reply to message #639898]

Mon, 20 July 2015 04:53

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/197888/639652/#msg_639652

Report message to a moderator

Previous Topic:	procedure error ger end of file
Next Topic:	Error with Delete Trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:17:58 CDT 2024