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

10 votes148 views1 answer
All_dependencies
SQL
0 vote161 views1 answer
Oracle winter time change
SQL
1 vote152 views1 answer
T-SQL / AZURE Reseed
SQL
5 votes131 views3 answers
Sql max value in column
SQL
0 vote149 views1 answer
How to read the potentail error messages in ssis package
SQL
1 vote148 views2 answers
Sql select only row with the max date
SQL
0 vote135 views1 answer
Mysql set variable to today's date
SQL
-1 vote135 views1 answer
Mysql order by on condition
SQL
0 vote143 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote138 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL