定义两个数组
TYPE CharArrayTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
TYPE NumArrayTyp IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
使用数组
PROCEDURE GetVoiceMsg(
sql_no_value in VARCHAR2,
Sql_no_length in INTEGER,
v_type out NumArrayTyp,
v_musicid out CharArrayTyp,
v_name out CharArrayTyp
); v_type(i):='adfasdf';
TYPE CharArrayTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
TYPE NumArrayTyp IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
使用数组
PROCEDURE GetVoiceMsg(
sql_no_value in VARCHAR2,
Sql_no_length in INTEGER,
v_type out NumArrayTyp,
v_musicid out CharArrayTyp,
v_name out CharArrayTyp
); v_type(i):='adfasdf';
如果支持递归算法,那么在递归函数的每一个实例里的变量是独立于其它实例的变量对吧?
我如何得到数组的长度?或者说,遍历数组元素以寻找等某特定值的元素的下标,如何写?