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 votes171 views2 answers
How to View column names of a table in SQL
SQL
0 vote188 views1 answer
Sql reverse order of results
SQL
1 vote174 views1 answer
Mysql connect command
SQL
0 vote195 views1 answer
Query builder doctrien return sql
SQL
1 vote173 views1 answer
Real world example of nosql
SQL
0 vote166 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote176 views1 answer
How to drop columns with constraint from a table in sql script
SQL
4 votes174 views1 answer
Sql query to make a existing column auto increment
SQL
1 vote175 views1 answer
Is sql fast
SQL
1 vote189 views1 answer
Mysql select and count left join
SQL