Good afternoon, gurus.



I have a table in which deletes and truncates occur regularly. I've now
been tasked with finding the 79,001 row in the table. This table has no
indexes, and is loaded nightly. Doing a query such as



Select * from table_name

Where rownum = 79001;



Returns no rows. There are currently 112,500 rows.



Does anyone have any insight (outside of creating a cursor to run
through the table until it hits the required row) on a simple SQL query
I could use?



Thanks in advance!



Jeff



Jeffrey Cote'

Sr. Oracle Database Admin.

H&R Block, Financial Advisors

313-628-1267

Jeff.[Email address protected] <mailto:Jeff.[Email address protected]



"Aut viam inveniam aut faciam."

Hannibal (247-182 BCE)



Note: This message, including attachments, is from H&R Block Financial Advisors,
Inc., Member NYSE, SIPC. This is not a solicitation of any order to buy or sell. The
information contained herein is deemed to be reliable but is in no way warranted by us as
to accuracy or completeness. Messages are monitored and retained by the Company, but
the company cannot guarantee the security of this message. The company, and its
associates, may not accept orders to affect purchase or sale transactions, accept funds,
securities, or similar instructions via email. If you are not the intended recipient of this
message promptly delete this message and notify the sender of the delivery error by
return email or calling 1.800.HRBLOCK and selecting the option for 'Financial Services'
You may not forward, print, copy, distribute, or use the information in this message if
you are not the intended recipient.

Oracle LazyDBA home page