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 vote270 views1 answer
Postgresql find missing id
SQL
6 votes270 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote284 views2 answers
How to get the date from datetime in mysql
SQL
-1 vote284 views5 answers
Operator in sql
SQL
0 vote245 views1 answer
Como leer datos de mysql esp32
SQL
0 vote268 views1 answer
Pl sql constraint user function
SQL
5 votes274 views1 answer
Sql check if date is between 2 dates
SQL
1 vote278 views1 answer
Sql restore backup query
SQL
0 vote281 views1 answer
How to list function in psql
SQL
3 votes261 views1 answer
Mysql load sql from file
SQL