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

1 vote185 views3 answers
Update from select sqlite
SQL
0 vote159 views1 answer
What is the essence of SQL?
SQL
10 votes170 views3 answers
Sql check double value
SQL
6 votes187 views2 answers
How to copy data in sql
SQL
20 votes159 views5 answers
Mysql reset auto increment to 1
SQL
21 votes189 views1 answer
SQL cheat sheet pdf
SQL
0 vote184 views1 answer
Sqlite trim
SQL
13 votes183 views2 answers
Sql join 3 tables
SQL
6 votes178 views1 answer
Oracle trigger after logon on schema
SQL
0 vote182 views1 answer
Savepoint mysql script
SQL