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 nvarchar in sql?
What is a subquery in sql?
What are the different dcl commands in sql?
What do you know by pl/sql cursors?
Does inner join remove duplicates?
how can we destroy the cookie? : Sql dba
What are the different types of sql commands?
Can we insert data in view?
Mention what are the benefits of pl/sql packages?
Is sql the best database?
what is a primary key? : Sql dba
What is sqlservr exe?
Can you upgrade sql express to full sql?
What is difference between cursor and trigger?
what is a cursor? : Sql dba