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

2 votes374 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
1 vote307 views1 answer
Mysqli connect
SQL
0 vote344 views1 answer
Sqlalchemy get schema from database
SQL
0 vote349 views1 answer
Alter boolean column postgresql
SQL
0 vote323 views1 answer
Partitioning in oracle-base
SQL
13 votes333 views6 answers
Mysql update from select
SQL
0 vote281 views1 answer
Oracle sysdba connect as another user
SQL
4 votes321 views1 answer
Mysql set max connections
SQL
0 vote362 views1 answer
Trigger vérifier stock
SQL
1 vote318 views3 answers
Postgresql connect to database
SQL