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 votes212 views1 answer
Sql delete where in select
SQL
0 vote243 views1 answer
Consecutive numbers sql
SQL
2 votes223 views1 answer
SQL IF ELSE
SQL
0 vote215 views1 answer
Sql put two columns into one
SQL
0 vote254 views1 answer
Traccar mysql
SQL
3 votes223 views1 answer
Only join in sql
SQL
3 votes215 views2 answers
How to start postgresql on windows
SQL
0 vote234 views1 answer
Python mysql show databases
SQL
0 vote213 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote179 views1 answer
Query for maximum salary
SQL