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;

How do you drop a trigger?

0 Answers  

---

Can u create a primary key with out unique index.

8 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

What is the difference between sql, mysql and sql server?

0 Answers  

---

How do sql triggers work?

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

How does stored procedure reduce network traffic?

0 Answers  

---

What do you mean by table in sql?

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 Answers  

---

Can we update views in sql?

0 Answers  

---