Oracle array

declare
   type array_t is varray(3) of varchar2(10);
   array array_t := array_t('Matt', 'Joanne', 'Robert');
begin
   for i in 1..array.count loop
       dbms_output.put_line(array(i));
   end loop;
end;

Similar codes

1 vote216 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote220 views1 answer
Sql server remove 0 from left
SQL
0 vote247 views1 answer
Mysql config address
SQL
0 vote224 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote259 views2 answers
Coursera spark sql max count
SQL
1 vote262 views1 answer
Backup mysql schema only
SQL
0 vote219 views1 answer
How to avoid duplicate records in sqlite
SQL
1 vote229 views1 answer
Mysql select another database
SQL
4 votes227 views2 answers
Error loading MySQLdb module.
SQL
0 vote230 views1 answer
Write sql query to show the details start from digit
SQL