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 vote163 views1 answer
Postgres start database on linux
SQL
2 votes174 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote145 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote143 views1 answer
Call procedure in wordpress
SQL
0 vote155 views1 answer
Check if string is a number sql
SQL
0 vote181 views1 answer
Sql create table with references not primary key
SQL
0 vote182 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote142 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote160 views1 answer
Will graphql replace sql
SQL
0 vote156 views1 answer
How to set all the min and sec data to zero in sql server
SQL