Hi,
I´ve some Problem to code a Little Loop with "my Special Needs".
I´ve a Table where I made a selection
Select id, value from Table_loop;
Then I´d like to use this in my plsq like:
DECLARE
var_id NUMBER;
var value varchar2 (20);
var_max number;
var_Loop number := 1;
BEGIN
var_max := select Count(id) from Table_loop;
LOOP
IF var_loop > var_max THEN exit;
?? var_id := "the next id from Select id, value from Table_loop;"
?? var_value := the next value from Select id, value from Table_loop;"
...
...
do something with the next id and value..
END;
..
..
thx