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 vote148 views1 answer
Tsql cmd exec script from file
SQL
-2 votes147 views1 answer
How to open database
SQL
0 vote155 views1 answer
Sql ignore
SQL
2 votes138 views1 answer
Oracle cpu per session
SQL
1 vote151 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote148 views1 answer
Systemverilog unique constraint unique values
SQL
4 votes141 views1 answer
Add constraint fk
SQL
15 votes153 views3 answers
Find duplicate keys in mysql
SQL
23 votes152 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote138 views1 answer
Search In the Database using Text
SQL