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;

what is the difference between where clause and having clause? : Sql dba

1007

---

What are actual parameters and formal parameters?

1112

---

How to start oracle sql developer?

1049

---

Is there any restriction on the use of union in embedded sql?

1164

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1062

---

Can we join same table in sql?

1034

---

what is try_catch block in procedure

1757

---

What is a unique constraint?

1083

---

What are aggregate and scalar functions?

1032

---

How many types of cursors supported in pl/sql?

1198

---

What is a join?

1076

---

How do I view a table in sql?

1013

---

List the various privileges that a user can grant to another user?

1047

---

What is delete command in sql?

1125

---

How do I create an index in word?

1039

---