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 vote170 views1 answer
Mysql error codeigniter
SQL
0 vote172 views1 answer
Mysql identified by syntax error
SQL
2 votes178 views1 answer
Drop all database tables oracle sql developer
SQL
4 votes175 views1 answer
Add constraint fk
SQL
4 votes197 views4 answers
Mysql get date from datetime
SQL
0 vote169 views1 answer
Mysqlimport
SQL
-1 vote176 views1 answer
Sql set max value in column
SQL
0 vote172 views1 answer
Redudancy in SQL
SQL
0 vote172 views1 answer
Sql get year from datetime field
SQL
5 votes171 views3 answers
String concatenation sql server
SQL