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

3 votes98 views3 answers
Start postgresql ubuntu
SQL
0 vote88 views1 answer
Sql last 7 days
SQL
0 vote95 views1 answer
Mysql concatenate select results
SQL
0 vote96 views1 answer
Price-colour
SQL
6 votes90 views2 answers
Oracle
SQL
0 vote107 views1 answer
How to create a new db from dumb file mysql
SQL
24 votes96 views4 answers
Postgres delete database
SQL
0 vote93 views1 answer
Search from comma separated values in sql server
SQL
1 vote55 views1 answer
Unique vs distinct sql
SQL
-1 vote99 views2 answers
Installing mysql on centos 7
SQL