创建 VARRAY 数组时，OceanBase 数据库不会为它分配空间。它定义了一种类型用来声明：

• 对象类型属性

创建可变数组的简单语法格式如下：

示例：创建可变数组

delimiter /
DECLARE
  TYPE Foursome IS VARRAY(4) OF VARCHAR2(15);  
  team Foursome := Foursome('John', 'Mary', 'Alberto', 'Juanita');
  PROCEDURE print_team (heading VARCHAR2) IS
  BEGIN
    DBMS_OUTPUT.PUT_LINE(heading);
    FOR i IN 1..4 LOOP
      DBMS_OUTPUT.PUT_LINE(i || '.' || team(i));
    END LOOP;
    DBMS_OUTPUT.PUT_LINE('---'); 
BEGIN 
  print_team('2001 Team:');
  team(3) := 'Pierre'; 
  team(4) := 'Yvonne';
  print_team('2005 Team:');
  team := Foursome('Arun', 'Amitha', 'Allan', 'Mae');
  print_team('2009 Team:');
END;
/
2001 Team:
1.John
4.Juanita
---
2005 Team:
1.John
2.Mary
3.Pierre
4.Yvonne
---
2009 Team:
1.Arun
2.Amitha
3.Allan
4.Mae