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

4 votes158 views1 answer
Oracle session date format
SQL
0 vote179 views1 answer
How to find total working hour in sql
SQL
1 vote337 views1 answer
Postgres convert text to number
SQL
0 vote177 views1 answer
Sql server size of every table in a db
SQL
4 votes238 views2 answers
Convert utc to est sql
SQL
0 vote159 views2 answers
Clear window pl sql
SQL
0 vote173 views1 answer
Oracle sql date summer time
SQL
1 vote161 views1 answer
Woocommerce mysql price table
SQL
0 vote228 views3 answers
Select top 10 rows in sql
SQL
1 vote207 views1 answer
Sql server if exists update else insert
SQL