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

2 votes106 views1 answer
Mysql admin u root p password change password
SQL
4 votes224 views4 answers
Remove duplicate old value in mysql
SQL
0 vote160 views1 answer
Mysql sleep connections
SQL
7 votes159 views2 answers
Mysql check db size
SQL
0 vote160 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote289 views1 answer
Generate a random otp in sql server
SQL
0 vote197 views1 answer
Change redo log file size in mysql 5.6
SQL
0 vote161 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote155 views2 answers
Disallowed function mysql to_date()
SQL
0 vote148 views1 answer
Check if record exists mysql
SQL