Yea, EF correct. Checked here:
CREATE package pkg as
type tab_typ is table of varchar2(10) index by PLS_INTEGER;
function tab_end (p_tab in tab_typ) return varchar2;
end pkg;
/
create package body pkg as
function tab_end(p_tab in tab_typ) return varchar2 is
begin
return p_tab.last;
end;
end pkg;
/
declare
l_stmt varchar2(100);
l_list pkg.tab_typ;
l_result varchar2(10);
begin
l_list(1) := 'Mon';
l_list(2) := 'Tue';
l_stmt := 'SELECT pkg.tab_end(:l_list) into :i_result from dual';
execute immediate l_stmt into l_result using l_list;
dbms_output.put_line(l_result);
end;
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
orakell
Highly Voted 5 years, 6 months agochrishillinger
Most Recent 2 years, 9 months agoCosminCof
4 years, 6 months agovlad4475
4 years, 8 months ago