Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL to split huge data into two files

838132Feb 16 2011 — edited Feb 16 2011
Hi,

I have a table which has around 1850000 records. I want to split the data into two sets and import the data in .txt or execl file.

How can i break upthe records using rownum or any thing

select * from tablename where rownum<940000 fetched some records
but
when i gave select * from tablename where rownum>940000 it was not fetching records.

Guideme
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2011
Added on Feb 16 2011
#sql-developer
2 comments
517 views