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 vote325 views3 answers
Mysql parse int
SQL
11 votes342 views6 answers
Mysql else if
SQL
0 vote330 views1 answer
Oracle tablespace autoextend
SQL
0 vote360 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote323 views1 answer
Connect laravel to mysql on mac
SQL
0 vote318 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote341 views1 answer
Mysql value ends with
SQL
1 vote313 views2 answers
Sql drop multiple columns if exists
SQL
0 vote345 views1 answer
Pgadmin check database
SQL
0 vote308 views1 answer
Console output pl sql
SQL