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 vote336 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote290 views1 answer
Drop constraint in ms sql
SQL
0 vote270 views1 answer
Mysql export data with a where clause
SQL
0 vote279 views1 answer
Sql insert tuple
SQL
0 vote281 views1 answer
Drop a field in psql django
SQL
0 vote267 views1 answer
Recursive query herarchical data sql server
SQL
5 votes272 views4 answers
Describe table postgres
SQL
0 vote297 views1 answer
Resullt all update knex mysql
SQL
0 vote281 views1 answer
Get number of tables in database sql
SQL
0 vote282 views1 answer
Difference between varchar and varchar2
SQL