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 votes148 views2 answers
Find string in stored procedure sql server
SQL
4 votes123 views1 answer
SQL order random
SQL
2 votes141 views2 answers
Sql query to copy data from one column to another
SQL
0 vote139 views1 answer
How to query without duplicate rows in sql
SQL
0 vote153 views1 answer
The fetch keyword oracle
SQL
1 vote125 views1 answer
Mysql batch insert
SQL
0 vote146 views1 answer
Alter column to not null with default value sql server
SQL
0 vote132 views1 answer
Mysql range of dates overlap
SQL
0 vote137 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote146 views1 answer
How to inner join 4 tables in sql
SQL