DECLARE
TYPE t_NumbersTab IS TABLE OF NUMBER; -- Create a table with one element.
v_Tab1 t_NumbersTab := t_NumbersTab(-1); -- Create a table with five elements.
v_Primes t_NumbersTab := t_NumbersTab(1, 2, 3, 5, 7); -- Create a table with one element, which itself is NULL.
v_Tab2 t_NumbersTab := t_NumbersTab();
BEGIN
-- Assign to v_Tab1(1). This will replace the value already
-- in v_Tab(1), which was initialized to -1.
v_Tab1(1) := 12345;
END;
/
TYPE t_NumbersTab IS TABLE OF NUMBER; -- Create a table with one element.
v_Tab1 t_NumbersTab := t_NumbersTab(-1); -- Create a table with five elements.
v_Primes t_NumbersTab := t_NumbersTab(1, 2, 3, 5, 7); -- Create a table with one element, which itself is NULL.
v_Tab2 t_NumbersTab := t_NumbersTab();
BEGIN
-- Assign to v_Tab1(1). This will replace the value already
-- in v_Tab(1), which was initialized to -1.
v_Tab1(1) := 12345;
END;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货