Write a procedure to return the month and the number of
developers joined in each month (cursor )
Answer Posted / 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
Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
What is a sql select statement?
What are the benefits of stored procedures?
What does a pl/sql package consist of?
What is synonyms?
What is union?
how to enter numeric values as hex numbers? : Sql dba
How insert into statements in sql?
Explain table and field in sql?
define join and explain different type of joins? : Sql dba
What is the difference between microsoft access and sql?
Which is faster truncate or drop?
What is the difference between delete, truncate and drop command?
What is implicit cursor in pl sql?
How do I truncate a word?
how tsql statements can be written and submitted to the database engine? : Transact sql