CREATE OR REPLACE PROCEDURE PRO IS CURSOR ECUR IS SELECT TO

Write a procedure to return the month and the number of
developers joined in each month (cursor )

Question Posted / rajesh venati

2 Answers
9609 Views
Tech Mahindra, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Why do we use view in sql?

935

how to fetch alternate records from a table? : Sql dba

1088

What kind of join is join?

949

What is a rank in sql?

944

Are sql database names case sensitive?

985

What is the primary use of normalization?

988

What is cursor status?

1178

Can you selectively load only those records that you need? : aql loader

1025

what is a tablespace? : Sql dba

1039

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1038

What is range partitioning?

951

What is difference between sql function and stored procedure?

991

How do you create a db file?

999

what is recursive stored procedure? : Sql dba

972

Is sql a backend language?

1077