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 vote352 views1 answer
Month mysql
SQL
9 votes342 views2 answers
Default number in sql
SQL
0 vote322 views1 answer
Mysql earlier than date
SQL
28 votes385 views6 answers
Foreign key
SQL
0 vote362 views1 answer
Kill a pid redshift
SQL
0 vote361 views1 answer
Mysql drop vs delete
SQL
0 vote371 views2 answers
Oracle select
SQL
0 vote376 views1 answer
Sql ignore
SQL
1 vote377 views1 answer
Mysql list bigger table
SQL
7 votes363 views2 answers
Oracle foreign key reference table
SQL