Created
November 12, 2012 14:00
-
-
Save fabioadrianosoares/4059551 to your computer and use it in GitHub Desktop.
PLSQL - Criar colecao e percorrer lista
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE | |
TYPE DEF_REGISTRO IS RECORD (CODIGO INT, DESCRICAO VARCHAR2(100)); | |
TYPE DEF_TABELA IS TABLE OF DEF_REGISTRO; | |
TABELA DEF_TABELA := DEF_TABELA(); | |
BEGIN | |
TABELA.EXTEND(1); | |
TABELA(TABELA.LAST).CODIGO := 1; | |
TABELA(TABELA.LAST).DESCRICAO := 'UM'; | |
TABELA.EXTEND(1); | |
TABELA(TABELA.LAST).CODIGO := 2; | |
TABELA(TABELA.LAST).DESCRICAO := 'DOIS'; | |
TABELA.EXTEND(1); | |
TABELA(TABELA.LAST).CODIGO := 3; | |
TABELA(TABELA.LAST).DESCRICAO := 'TRES'; | |
FOR i IN tabela.first..tabela.last LOOP | |
DBMS_OUTPUT.PUT_LINE(tabela(i).codigo || ' - ' || tabela(i).descricao); | |
END LOOP; | |
END; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment