Answer / rajesh venati

CREATE OR REPLACE PROCEDURE PRO
IS
CURSOR ECUR IS SELECT TO_CHAR(HIREDATE,'MON')
V_MONTH,COUNT(*) V_NO FROM EMP GROUP BY TO_CHAR(HIREDATE,'MON');
BEGIN
FOR V_ECUR IN ECUR LOOP
DBMS_OUTPUT.PUT_LINE(V_ECUR.V_MONTH||' '||V_ECUR.V_NO);
END LOOP;
END;


SQL> EXEC PRO;
DEC 3
APR 2
NOV 1
SEP 2
FEB 2
JUN 1
MAY 2
JAN 1

Answer / prabhudatta barick

CREATE OR REPALCE PROCEDURE EMP_PRO
IS
BEGIN

FOR EMP_CUR IN(SELECT SUBSTR(EMP_DOA,4,3) MONTH,
COUNT(*) NO_OF_EMP
FROM HRD_EMPLOYEETB
GROUP BY SUBSTR(EMP_DOA,4,3)
ORDER BY 1)
LOOP

DBMS_OUTPUT.PUT_LINE(EMP_CUR.MONTH||' '||EMP_CUR.NO_OF_EMP);


END LOOP;

END;

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

what are the join types in tsql? : Transact sql

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---

What is meant by truncate in sql?

0 Answers  

---

What does cursor do in sql?

0 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

Can we use having without group by in sql?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

0 Answers  

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---