Hello, this might be very basic question for you. I have a SQL statement that returns more than 150,000 tuples. I want to break the result to process. I mean I want to process the first 100,000 records first, then rest. Is there anyway I can break this by SAMPLING... I am using Oracle 8i PL/SQL.. Any help would be appriciated. TY