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

1 vote124 views1 answer
Sqlserver create table from select
SQL
16 votes117 views2 answers
Mysql date between two dates
SQL
0 vote106 views1 answer
Mysql workbench indent formatting
SQL
23 votes104 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
10 votes187 views2 answers
Doublon sql
SQL
0 vote201 views1 answer
Run mysql xampp shell
SQL
0 vote112 views1 answer
Order by monthly in sql
SQL
0 vote112 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote165 views1 answer
How to compile a function in oracle
SQL
0 vote117 views1 answer
Generate sequence number in sql server
SQL