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 vote363 views2 answers
Sql last updated
SQL
8 votes350 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote366 views1 answer
Excel export from sql using python
SQL
0 vote387 views2 answers
Mysql dump database tables only
SQL
0 vote364 views2 answers
Sqlalchemy core in clause
SQL
0 vote357 views2 answers
Mysql create table if not exists
SQL
3 votes445 views1 answer
Oracle nextval insert
SQL
0 vote352 views1 answer
Sql get number of days between two dates
SQL
0 vote372 views1 answer
Nodejs sql get one to many relationship as array
SQL
2 votes358 views1 answer
Mysql sysdate - 1 day
SQL