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

8 votes99 views1 answer
Oracle add month
SQL
0 vote123 views1 answer
Alter fedora mysql 8.0 user
SQL
9 votes116 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote115 views1 answer
Query only first letter string
SQL
1 vote60 views1 answer
Python escape string for sql
SQL
1 vote125 views1 answer
T-sql disable system versioning
SQL
0 vote94 views2 answers
Android sqlite query join
SQL
0 vote110 views4 answers
Database stuck at restoring state
SQL
0 vote103 views1 answer
Postgresql function ROUND
SQL
4 votes106 views2 answers
Oracle default date format
SQL