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 vote157 views1 answer
How to connect to mysql in ef 6
SQL
2 votes147 views1 answer
How to select first row of database sql
SQL
0 vote145 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote181 views1 answer
Sql decimal to 2 places
SQL
0 vote151 views1 answer
Create table database in psql
SQL
2 votes171 views1 answer
Sql get the name of user pc
SQL
0 vote146 views2 answers
Drop check constraint in ms sql
SQL
2 votes167 views2 answers
Storing timezones in postgres
SQL
0 vote155 views1 answer
Mysql database hyphen
SQL
9 votes173 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL