| every second row displayed [message #86576] |
Tue, 12 October 2004 08:55 |
hudo
Messages: 165
Registered: May 2004
|
Senior Member |
|
|
Hello,
with a PROCEDURE:
DECLARE
elem NUMBER := 1 ;
total NUMBER :=0 ;
BEGIN
FOR rec IN (SELECT * FROM emp)
LOOP
IF ( (MOD(elem,2) = 0) AND (total < 4) ) THEN
DBMS_OUTPUT.PUT_LINE('Output total elem: '||total||' '||elem||' '||rec.ename);
total := total +1;
END IF;
elem := elem +1;
END LOOP;
END;
I get every second row, but max 4 rows together.
How can I do/display just those 4 rows in forms ?
Can this be eventually done with forms builtins/ in a generic way ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
