Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 12327 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / neelaveni
declare
/*cursor c_bonus
is
select * from empsal; */
begin
for i in (select * from empsal)
loop
if i.job='salesman' then
i.bonus:=i.sal*10/100;
elsif i.job='mgr' then
i.bonus:=i.sal*20/100;
elsif i.job='analyst' then
i.bonus:=i.sal*30/100;
end if;
dbms_output.put_line('The ename is : '||i.ename);
dbms_output.put_line('The sal is : '||i.sal);
dbms_output.put_line('The job is : '||i.job);
dbms_output.put_line('The bonus is : '||i.bonus);
end loop;
end;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a recursive stored procedure?
What is the purpose of the sql select top clause?
Explain what is a view?
What is a natural join?
Does execute immediate commit?
What is a delimiter in sas?
What are all the ddl commands?
What is latest version of sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is the difference between where clause and having clause? : Sql dba
What will you get by the cursor attribute sql%notfound?
What is the non-clustered index in sql?
What is difference between hql and native sql?
how many sql dml commands are supported by 'mysql'? : Sql dba
Can I join the same table twice?
