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

0 vote325 views1 answer
Procedure excute monthly oracle
SQL
1 vote308 views1 answer
Float precision in psql
SQL
1 vote286 views3 answers
Default password of mysql
SQL
1 vote301 views1 answer
Show structure of table in sql
SQL
0 vote313 views1 answer
Delete data from database sqlite android
SQL
1 vote287 views1 answer
Varchar plsql
SQL
-1 vote358 views4 answers
Full outer join in sql
SQL
0 vote309 views1 answer
Can't connect to postgresql mac os
SQL
1 vote312 views4 answers
Sql now
SQL
0 vote291 views1 answer
Describe in sqlite3
SQL