Examine this code: ALTER SESSION SET plsql_warnings='ENABLE:ALL'; / You compile this function: What happens when the function is created with PLSQL_WARNINGS set to 'ENABLE: ALL'?
A.
It fails compilation.
B.
There are no compilation warnings or errors.
C.
A severe compilation warning is generated.
D.
A performance compilation warning is generated.
E.
An information compilation warning is generated.
The PLW-06002: Unreachable code warning is an informational compilation warning, not a performance-related warning. It alerts the developer that there is code in the program that will never be executed due to the control flow, but it does not impact the performance of the compiled code.
E is correct.
create or replace function get_val(x number, y number) return number authid definer is
begin
if x > y then return x;
elsif y = x then return y;
else return x + y;
end if;
return 100;
end;
Compiler displays a warning:
PLW-06002: Unreachable code
When: alter session set plsql_warnings = 'enable:informational';
Not when: alter session set plsql_warnings = 'enable:performance';
upvoted 4 times
...
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.
VAJAM
5 months agojm9999
1 year, 6 months agoghostwriter7
1 year, 6 months ago