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

0 vote235 views1 answer
Double in sql server example
SQL
0 vote177 views1 answer
How to get n result in sql
SQL
25 votes215 views3 answers
Mysql command show tables
SQL
1 vote244 views1 answer
Pgsql sum switch case
SQL
0 vote184 views1 answer
Dapper run sql script with parameters
SQL
1 vote170 views1 answer
What is int in mysql
SQL
1 vote195 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote201 views1 answer
Select inside insert query
SQL
12 votes176 views4 answers
How to take database dump in postgresql
SQL
0 vote197 views1 answer
Product of a column in mysql
SQL