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 vote287 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote417 views5 answers
Right join
SQL
0 vote277 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote317 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote282 views1 answer
Import local sql into remote mysql
SQL
0 vote280 views1 answer
Sql examples from your work
SQL
8 votes313 views1 answer
Oracle add datafile to tablespace
SQL
0 vote321 views3 answers
Call to undefined function mysql_connect()
SQL
4 votes289 views1 answer
Id primary key auto generated
SQL
1 vote320 views1 answer
Second last highest id in sql
SQL