Please answer my question;
thanks in advance
create or replace function del_rows
(p_table_name varchar2,p_empNo number)
Return Number
Is
begin
Execute immediate
'Delete from '||p_table_name||
' where empno= '||p_empNo;
Return SQL%RowCount;
end;
/
Which 2 statements are correct?
A) The Function goes through only the parse & execute
phases.
B) The function goes through the parse, bind & execute
phases.
C) The function goes through the parse, bind, execute &
fetch phases.
d)All the processing phases for the function are
performed only at run time.
e)Only the execute immediate statement inside the
function is parsed at run time.
dBforums
>
function question in 1z0-144 dmp file - waiting for u answers
01-07-12, 13:06
Linear Mode
