Answer / prasuna

Alternate 1

Define a cursor which holds the empname,salary and annual
renumeration
Use this cursor in a PL/SQL Block to find the emps who earn
30000 or more.

example :
Declare
cursor cl is select empname,salary,(salary*12)annual
renumeration
Begin
for i in cl
Loop
if i.annual renumeration > 30000 then
dbmsoutput.putline(empname);
end if
end

Approarch2
Write a stored function the take emp salary as i/p and
returns annual salary

Using this function in select statement can find the list
of emps who earn more than 30000

Answer / ajit nayak

select ename,sal,(sal*12)
from emp
where (sal*12) > 30000;

Answer / padmalatha

select Empno,Annual_Salary=sum(Month_Salary) from
Employee_Salary
group by Empno having sum(Month_Salary)>30000

Answer / venkat

Declare
cursor cl is select ename,sal,(sal*12) AS annualSAL FROM EMP;
i emp%rowtype;
Begin
for i in cl
loop
if i.annualSAL > 30000 then

dbms_output.put_line(i.ename);

end if;
end loop;
end;

Answer / kingston

i don't know

What are sql procedures?

0 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

What is mutating table?

11 Answers   Saama Tech,

---

What is 19 null in sql?

0 Answers  

---

How do I partition a table in sql?

0 Answers  

---

---

How sql query is executed?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What are the types of views in sql?

0 Answers  

---

Explain the the delete statements in sql?

0 Answers  

---

What is a scalar value in sql?

0 Answers  

---

Is a table valued function object?

0 Answers  

---