Loop in pl / sql oracle

Question

Loop in pl / sql oracle

Navigation

#1 by (1 votes)

0

I want to know how to go through all the tuples that are stored in a table; how do I do this in PL / SQL Oracle ?

Thank you in advance!

sql oracle11g pl-sql

asked by anonymous 28.04.2017 / 21:02

1 answer

Query where result equal to any of the values in the list I can not apply Encoder in the text to correctly appear "ç, accents, other special characters"

score 1 · Accepted Answer

I understand that you want to use a cursor . In PL/SQL you can do using FOR .
Suppose you have a table with the Code and Name fields, an example would look like this:

FOR i IN (SELECT Codigo, Nome FROM Tabela)
LOOP
    /*Aqui é possível ler cada campo da tupla usando a variável "i"*/
    DBMS_OUTPUT.PUT_LINE(i.Codigo||' '||i.Nome);
END LOOP;