OraFAQ Forum: Forms » fetching records

Blog
Search
Help
Members
Register
Login
Home

Home » Developer & Programmer » Forms » fetching records

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

fetching records [message #193742]

Tue, 19 September 2006 04:05

webadministrator
Messages: 45
Registered: October 2005

Member

hello,

if we want to jump 50 records each time when we click next,of total records of 10000 from database is it possible to be done?

thank u.

Report message to a moderator

Re: fetching records [message #193767 is a reply to message #193742]

Tue, 19 September 2006 06:05

jowahl
Messages: 82
Registered: May 2006

Member

define a trigger:

BEGIN
    FOR i IN 1..50
    LOOP
        IF :SYSTEM.LAST_RECORD = 'TRUE' THEN
           EXIT;
        END IF;
        --
        NEXT_RECORD;
        --
    END LOOP;
END;

Report message to a moderator

Previous Topic:	exporting & importing
Next Topic:	Form query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:53:52 CDT 2024