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

1 vote203 views1 answer
Find a column in all tables postgres
SQL
0 vote207 views1 answer
Alter table change default
SQL
0 vote238 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote265 views1 answer
Compare two tables to find unmatched records
SQL
0 vote195 views2 answers
Psql commande \gset
SQL
4 votes197 views3 answers
Employee name starting with in sql
SQL
11 votes230 views5 answers
Laravel db facade
SQL
0 vote202 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote208 views1 answer
Postgres reorder columns
SQL
1 vote222 views1 answer
Increase existing date in sql oracle
SQL