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

32 votes196 views6 answers
Insert into values select
SQL
0 vote182 views1 answer
How to save data in database in mysql node
SQL
0 vote194 views1 answer
Oracle temporary table
SQL
0 vote209 views1 answer
Acutal month year
SQL
0 vote207 views2 answers
Port 5432 is already in use mac
SQL
1 vote185 views1 answer
DATE_SUB postgres
SQL
0 vote187 views1 answer
Sql roll up rows into columns
SQL
4 votes187 views1 answer
Wilayah indonesia sql
SQL
0 vote189 views1 answer
How to find top 3 salary in sql
SQL
0 vote194 views1 answer
Database timezone
SQL