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

-2 votes139 views2 answers
Add auto_increment column to existing table mysql
SQL
20 votes143 views6 answers
Creating a table in sql
SQL
0 vote143 views1 answer
Count in sql and diff
SQL
0 vote120 views1 answer
Json not contains mysql
SQL
0 vote125 views1 answer
Mysqldump ignore table
SQL
11 votes123 views5 answers
Laravel db facade
SQL
5 votes123 views2 answers
Oracle to_timestamp
SQL
0 vote140 views1 answer
Mysql remove last character
SQL
11 votes82 views1 answer
Reset identity sql server
SQL
19 votes132 views6 answers
Sql drop table if exists
SQL