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;

what is a materialized view? : Sql dba

0 Answers  

---

How to run pl sql program in mysql?

0 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---

diff b/w function and procedure?

9 Answers   iFlex,

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

0 Answers  

---

What are all ddl commands?

0 Answers  

---

What is a left join?

0 Answers  

---

what are the different type of sql's statements ? : Sql dba

0 Answers  

---

Can we use view in stored procedure?

0 Answers  

---