Oracle for loop on list

declare
  type nt_type is table of number;
  nt nt_type := nt_type (1, 3, 5);
begin
  for i in 1..nt.count loop
    dbms_output.put_line(nt(i));
  end loop;
end;

Source: stackoverflow.com

Similar codes

3 votes250 views2 answers
Oracle privileges users
SQL
0 vote263 views1 answer
For row in sql database python loop
SQL
0 vote227 views1 answer
Renommer table sql
SQL
0 vote261 views1 answer
Bitmap join index
SQL
0 vote256 views1 answer
Psotgres multiple values
SQL
10 votes204 views2 answers
Sql where clause multiple values
SQL
0 vote231 views1 answer
Oracle sql winter time change
SQL
3 votes234 views2 answers
Sql random integer
SQL
0 vote249 views1 answer
Consulta alias con inner join
SQL
0 vote225 views1 answer
AddEntityFrameworkSqlite
SQL