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

3 votes121 views1 answer
Sql replace character in string in all records
SQL
2 votes119 views1 answer
Oracle index size calculation
SQL
4 votes189 views1 answer
Mysql store ip address
SQL
15 votes136 views5 answers
Select all tables sql
SQL
0 vote122 views1 answer
Object Information
SQL
0 vote169 views1 answer
Sql check if field is not null
SQL
0 vote150 views1 answer
Mysql could not fetch tables
SQL
2 votes126 views2 answers
Run mysql command from bash
SQL
0 vote209 views1 answer
Run mysql xampp shell
SQL
0 vote128 views1 answer
Insert overwrite table in mysql in nifi
SQL