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

Is a table valued function object?

0 Answers  

---

Enlist the data types that can be used in pl/sql?

0 Answers  

---

What is range partitioning?

0 Answers  

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

---

Why are sql stored procedures used?

0 Answers  

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

How do you pronounce sql?

0 Answers  

---

Show how functions and procedures are called in a pl/sql block.

0 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---