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

1 vote201 views1 answer
Where date = max(date) in sql
SQL
0 vote207 views1 answer
Check if string is a number sql
SQL
5 votes251 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote196 views1 answer
Min mysql
SQL
4 votes304 views1 answer
Sql select limit range
SQL
2 votes209 views2 answers
Mysql count rows returned
SQL
0 vote239 views2 answers
Sql update multiple tables
SQL
13 votes211 views5 answers
Sql default
SQL
0 vote219 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote202 views1 answer
Group by sql not ordering issues
SQL