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

38 votes435 views6 answers
Ubuntu install mysql client
SQL
0 vote340 views1 answer
Add computed column to table sql server
SQL
0 vote357 views1 answer
Mysql extract day from date leading zero
SQL
0 vote335 views1 answer
Sql delete dastabase
SQL
0 vote326 views1 answer
Sql database size
SQL
2 votes357 views3 answers
Sql truncate table
SQL
0 vote335 views1 answer
Mysql workbench view
SQL
2 votes353 views1 answer
Select sid oracle
SQL
-1 vote331 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote335 views1 answer
Contact mysql column field
SQL