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 vote128 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote106 views1 answer
Sql server whoami
SQL
0 vote116 views1 answer
Replace sqlalchemy
SQL
8 votes112 views1 answer
Oracle current date plus 1 month
SQL
0 vote103 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote123 views1 answer
Mysql bash execute sql file
SQL
-1 vote108 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote114 views1 answer
Sql server get users
SQL
0 vote122 views2 answers
Mysql add days to date
SQL
2 votes132 views3 answers
Postgres create view
SQL