Skip to content

Instantly share code, notes, and snippets.

@kllaudyo
Created December 3, 2018 17:38
Show Gist options
  • Save kllaudyo/02f72a675480f94b80b704bdd79dbac6 to your computer and use it in GitHub Desktop.
Save kllaudyo/02f72a675480f94b80b704bdd79dbac6 to your computer and use it in GitHub Desktop.
Iterando cursor com "FOR IN"
CREATE OR REPLACE PROCEDURE SAMPLE_CURSOR_IN AS
CURSOR UFS IS
SELECT ID_UF, NM_UF
FROM UNIDADES_FEDERACAO;
BEGIN
FOR J IN UFS
LOOP
CONTENT := '{"sigla":"'|| J.ID_UF ||'","nome":"'|| J.NM_UF ||'"}';
END LOOP;
DBMS_OUTPUT.PUT_LINE(CONTENT);
END; --SAMPLE_CURSOR_IN
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment