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

10 votes173 views3 answers
Join multiple tables sql
SQL
0 vote191 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote190 views1 answer
Drop specific row postgresql
SQL
0 vote188 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote160 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote170 views1 answer
Dump db only triggers mysql
SQL
8 votes176 views1 answer
Sql remove leading spaces
SQL
8 votes186 views1 answer
Oracle search text in all packages
SQL
3 votes181 views1 answer
Postgres select max value
SQL
1 vote139 views1 answer
Unique vs distinct sql
SQL