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

3 votes168 views2 answers
How to force truncate a table in mysql
SQL
0 vote152 views1 answer
Pagination with row_number
SQL
11 votes228 views1 answer
Oracle insert from select
SQL
6 votes164 views1 answer
Identify primary key in oracle table
SQL
3 votes177 views1 answer
Apex set debug level
SQL
0 vote185 views1 answer
How to check event scheduler status mysql
SQL
0 vote264 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote146 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote155 views1 answer
Postgresql print sessions using the database
SQL
0 vote151 views1 answer
Import sql in postgresql
SQL