Plsql loops

From John Freier
Revision as of 14:12, 2 July 2013 by Jfreier (Talk | contribs) (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;')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
DECLARE

BEGIN

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

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

     END LOOP;

END;
Retrieved from "http://wiki.johnfreier.com/index.php?title=Plsql_loops&oldid=537"