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
9649 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

Where is pl sql used?

954

what is offset-fetch filter in tsql? : Transact sql

949

How to rename a table?

1023

What is aggregate function in sql?

1040

Mention what are the benefits of pl/sql packages?

1082

What is a sql profiler?

1028

What is the difference between microsoft access and sql server?

1060

what is datawarehouse? : Sql dba

1017

Which are the different character-manipulation functions in sql?

1065

How to run sql*plus commands in sql developer?

1159

Why sql query is slow?

1001

What pl/sql package consists of?

1082

What view means?

979

What are the properties of a transaction?

1128

Is record in oracle pl sql?

964