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 vote172 views1 answer
Joins vs includes
SQL
0 vote164 views1 answer
Oracle synonym procedure
SQL
10 votes202 views4 answers
Mysql one week ago
SQL
3 votes201 views1 answer
RENAME table pl sql
SQL
0 vote168 views1 answer
Why we have to set the password for my sql server
SQL
0 vote226 views2 answers
How to take recent row without limit in mysql
SQL
1 vote363 views2 answers
Coderbyte sql solutions
SQL
6 votes172 views5 answers
Sql add months to date
SQL
0 vote182 views3 answers
Sql drop all tables
SQL
2 votes179 views1 answer
Mysql create user with mysql_native_password
SQL