Difference between revisions of "Plsql loops"
From John Freier
(Created page with ' DECLARE BEGIN FOR c_user IN (SELECT user_id, name FROM user) LOOP dbms_output.put_line('username:' || c_user.name); END LOOP; END;') |
|||
| Line 1: | Line 1: | ||
| + | Loop through a record set and use the records. | ||
DECLARE | DECLARE | ||
Latest revision as of 14:13, 2 July 2013
Loop through a record set and use the records.
DECLARE
BEGIN
FOR c_user IN (SELECT user_id, name FROM user)
LOOP
dbms_output.put_line('username:' || c_user.name);
END LOOP;
END;
