declare cursor c1 is select * from emp; begin for i in c1 loop if i.jo

using cursors salesman get bonus as 10% of their salary ,
managers get 20% , analalist get 30%. generae a report
showing the employee name, salary , bonus.

Question Posted / narenkumar reddy

4 Answers
12325 Views
Fidelity, I also Faced
E-Mail Answers

Answer Posted / narenkumar reddy

declare
cursor c1 is select * from emp;
begin
for i in c1
loop
if i.job='salesman' then
bonus:=sal+sal*10/100;
elsif i.job='manager' then
bonus:=sal+sal*20/100;
elsif i.job='analyst' then
bonus:=sal+sal*30/100;
end if;
dbms_output_output.put_line(i.ename||i.sal||i.sal||bonus);
end;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to test for null values?

1098

Can we join same table in sql?

1068

Is foreign key mandatory?

1064

What is db journal file?

1158

What do you understand by pl/sql cursors?

1149

What is sql character function?

1152

Explain 3 basic parts of a trigger.

1376

Is truncate ddl or dml?

1038

Can we join more than 2 tables in sql?

1094

What is implicit cursor in pl sql?

1149

What is write ahead logging in sql server?

1101

What does (*) mean in sql?

1002

what is the difference between group by and order by in sql? : Sql dba

1188

What does seeding a database mean?

1024

What is data types in sql?

1070