DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1; END;
-- Reference to uninitialized collection
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2);
BEGIN
dbms_output.put_line(my_tab(1)); --2
my_tab(1) :=55;
dbms_output.put_line(my_tab(1)); --55
END;
-- Executes successfully
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := 55; END;
-- Reference to uninitialized collection
DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type(); my_tab (1) := 55; END;
-- Subscript beyond count
The ANs E missing ";" "end;". Anyhow i check it and seems that the correct answers are BC.
The answer E could be fine if it was :
"DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2); END;"
and not
DECLARE TYPE tab_type IS TABLE OF NUMBER my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2);
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Tinamoran
Highly Voted 5 years, 3 months agoWrath
Highly Voted 5 years, 3 months agoRakeshpro
Most Recent 2 years, 4 months agoRakeshpro
2 years, 4 months agochrishillinger
2 years, 5 months agoCosminCof
4 years, 2 months agocertyk
4 years, 4 months agocertyk
4 years, 4 months agoszefco
4 years, 8 months ago