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 vote99 views1 answer
Sql case when exists in another table
SQL
0 vote99 views1 answer
What is ssrs and ssis in sql server
SQL
6 votes109 views5 answers
Sql add months to date
SQL
1 vote170 views1 answer
Oracle current sequence value
SQL
0 vote99 views1 answer
Why we have to set the password for my sql server
SQL
1 vote110 views1 answer
Change table to innodb mysql
SQL
53 votes261 views6 answers
Sql server alter column
SQL
0 vote93 views1 answer
Mysql earlier than date
SQL
0 vote101 views1 answer
Sql find leading space
SQL
1 vote101 views2 answers
End mysql command
SQL