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

0 vote99 views1 answer
Mysql where don't have string
SQL
1 vote99 views1 answer
Sql auto date
SQL
0 vote164 views1 answer
Tsql find procedure with name
SQL
0 vote97 views2 answers
Clear window pl sql
SQL
-2 votes110 views1 answer
No module named '_sqlite3
SQL
0 vote113 views2 answers
How to drop mili second in sql
SQL
1 vote109 views1 answer
Convert varchar to int in sqlite
SQL
0 vote114 views1 answer
No suitable driver found for sqlite
SQL
0 vote105 views1 answer
How to select only id where is not in column mysql
SQL
22 votes101 views4 answers
Show list of users in mysql
SQL