Home » SQL & PL/SQL » SQL & PL/SQL » Re: Array
Re: Array [message #39281] Tue, 02 July 2002 21:53
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Scalar array:

declare
  type tab_number_type is table of number index by binary_integer;  -- declare the array type
  v_tab_number  tab_number_type;  -- declare a variable of the array type
begin
  v_tab_number(1) := 123;
  v_tab_number(2) := 234;
end;


Record array:

declare
  type rec_array_type is record(x number, y varchar2(10));
  type tab_array_type is table of rec_array_type index by binary_integer;  -- declare the array type
  v_tab_array  tab_array_type;  -- declare a variable of the array type
begin
  v_tab_number(1).x := 123;
  v_tab_number(1).y := 'Koala';
end;
Previous Topic: How I know if exists statistics from a table ?
Next Topic: Package Initialization
Goto Forum:
  


Current Time: Fri Apr 26 13:28:09 CDT 2024