Difference between revisions of "Plsql loops"

From John Freier
Jump to: navigation, search
(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;')
(No difference)

Revision as of 14:12, 2 July 2013

DECLARE

BEGIN

     FOR c_user IN (SELECT user_id, name FROM user)
     LOOP

          dbms_output.put_line('username:' || c_user.name);

     END LOOP;

END;