C: show all products
set SERVEROUTPUT ON
declare
inc number := .01;
cursor pdt is
select proceso as prodname,(precio*inc) aumento from producto;
begin
for pdt_rec in pdt loop
dbms_output.put_line('prod name '||pdt_rec.prodname|| ' price increm ' ||
pdt_rec.aumento );
inc := inc +.01;
end loop;
end;
prod name VIRTUAL price increm .03
prod name CONCILIACION price increm .01
prod name COBRANZA price increm .02
prod name SOLICITUD DE NOTA DE CREDITO price increm .04
You put an alias on the cursor field in your code. That is why your code did not generate an error. And the correct answer is "A" because alias is needed.
upvoted 1 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 agogusa
4 years, 9 months agovlad4475
4 years, 7 months ago