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

1 vote192 views1 answer
Update and replace mysql
SQL
-2 votes200 views1 answer
Mysql see users and passwords
SQL
2 votes194 views1 answer
Oracle index size
SQL
4 votes187 views1 answer
Restart for pg_hba.conf file
SQL
0 vote313 views4 answers
Stored procedure sql
SQL
0 vote234 views1 answer
Download mysql database to excel in android studio
SQL
1 vote195 views1 answer
Oracle nvl2
SQL
1 vote194 views2 answers
Sql server concat string and int
SQL
0 vote186 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
11 votes242 views3 answers
Pl sql example
SQL