display the nth row

[jennifer2007]

Oh my...you dont get me hunnies

its not export or import using oracle....

The scenario is:

1. I have EMP table in oracle witn 300,000+ rows.
2. I want to convert to to foxpro.dbf. (i have done this to other tables
and they are successful except this EMP).
The easiest way to convert is using the odbc export utility in MSSQL server.
there is an export util there (its not an oracle export). where u can export
any database to other database using the odbc DSN.

i just hit error on the 119,823rd row. and i want to display all info about this
row for investigation.

"rows in oracle anrent in any order, you get them in whatever order the database wants to give you them" - davey
Of course I only want to get the default sequence and it wont change
the order of it even if u run hundred times. the EMP is just staging table,
no other is using it.

anyway i make research in pl/sql and i made this program:
===========================================

DECLARE
a_rowid varchar2(18);
a_rownum number;
CURSOR c1 IS
SELECT rowid, rownum from EMP;
BEGIN
open c1;
LOOP
FETCH c1 INTO a_rowid, a_rownum;
if a_rownum between 119822 and 119824
then
INSERT INTO temp VALUES (a_rowid,a_rownum);
end if;
COMMIT;
END LOOP;
close c1;
END;
/

But this program runs very long time and eats lots of CPU. can u tune
this one please

Thanks