Skip to content
October 9, 2015 / doganay

EXPORTING 1 MILLION ROW TO EXCEL USING SQL NAVIGATOR

When sql navigator exporting data as excel file, maximum allow row count is 65535.

So you can split your data into pieces or you can use another tool(toad, etc.)

Usually you get different errors when exporting  ~1 million rows in toad.

select * from (select rownum r,a.* from t1 a) where r>=0 and r<50000;
select * from (select rownum r,a.* from t1 a) where r>=50000 and r<100000;
select * from (select rownum r,a.* from t1 a) where r>=100000 and r<150000;
select * from (select rownum r,a.* from t1 a) where r>=150000 and r<200000;
select * from (select rownum r,a.* from t1 a) where r>=200000 and r<250000;
select * from (select rownum r,a.* from t1 a) where r>=250000 and r<300000;
select * from (select rownum r,a.* from t1 a) where r>=300000 and r<350000;
select * from (select rownum r,a.* from t1 a) where r>=350000 and r<400000;
select * from (select rownum r,a.* from t1 a) where r>=400000 and r<450000;
select * from (select rownum r,a.* from t1 a) where r>=450000 and r<500000;
select * from (select rownum r,a.* from t1 a) where r>=500000 and r<550000;
select * from (select rownum r,a.* from t1 a) where r>=550000 and r<600000;
select * from (select rownum r,a.* from t1 a) where r>=600000 and r<650000;
select * from (select rownum r,a.* from t1 a) where r>=650000 and r<700000;
select * from (select rownum r,a.* from t1 a) where r>=700000 and r<750000;
select * from (select rownum r,a.* from t1 a) where r>=750000 and r<800000;
select * from (select rownum r,a.* from t1 a) where r>=800000 and r<850000;
select * from (select rownum r,a.* from t1 a) where r>=850000 and r<900000;
select * from (select rownum r,a.* from t1 a) where r>=900000 and r<950000;
select * from (select rownum r,a.* from t1 a) where r>=950000 and r<1000000;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: