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 vote189 views1 answer
Select random sample sql
SQL
2 votes179 views1 answer
Check isolation level in mysql
SQL
0 vote182 views1 answer
How to use query in nosql
SQL
0 vote185 views1 answer
Drop procedure sql
SQL
0 vote184 views1 answer
Addition of 2 column value in mysql
SQL
0 vote258 views1 answer
SQL Server Altering Column to be Unique
SQL
5 votes183 views2 answers
Mysql import gzip db
SQL
0 vote183 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote183 views1 answer
Groupby sort sql hive
SQL
0 vote179 views1 answer
Insert set mysql
SQL