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

2 votes277 views2 answers
How to DROP a table in mysql
SQL
0 vote295 views1 answer
Sql query to force the database to be drop
SQL
22 votes290 views4 answers
Mysql date_format
SQL
0 vote296 views3 answers
How to run sql query
SQL
0 vote309 views2 answers
Port 5432 is already in use mac
SQL
0 vote291 views1 answer
Lost connection to mysql
SQL
10 votes273 views4 answers
Mysql one week ago
SQL
3 votes271 views1 answer
How to uninstall microsoft sql server
SQL
1 vote284 views2 answers
Sql queries practice
SQL
13 votes271 views2 answers
Mysql order by multiple columns
SQL