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 vote142 views3 answers
What is union in sql
SQL
0 vote143 views1 answer
Oracle simple quote
SQL
26 votes142 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote133 views1 answer
Using SQL in rails migration
SQL
0 vote152 views1 answer
Sql server concat null
SQL
0 vote142 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote156 views1 answer
How we can perform acid Operations in sql with examples
SQL
6 votes152 views2 answers
Where clause in sql
SQL
4 votes135 views3 answers
Oracle sql first day of quarter
SQL
1 vote145 views1 answer
Give a column name to values generated from case statement in sql
SQL