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

23 votes226 views6 answers
Delete all rows from table sql
SQL
0 vote237 views1 answer
Csv to sqlite python
SQL
0 vote225 views1 answer
Console output pl sql
SQL
1 vote240 views1 answer
Oracle nvl2
SQL
0 vote277 views1 answer
How to find unique element in sql
SQL
0 vote253 views1 answer
Hour and minute between two datatime sql
SQL
0 vote223 views1 answer
How to retrive the today date sql
SQL
0 vote236 views1 answer
Subquery aggregation
SQL
12 votes230 views6 answers
Select distinct
SQL
0 vote230 views1 answer
Sql sum show 0 result
SQL