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

what is normalization? : Sql dba

1078

What are some emotional triggers?

975

What are the advantages of indexing?

980

can sql servers linked to other servers like oracle? : Sql dba

1000

What is a sql select statement?

1032

Why do we need unique key in a table?

952

Explain the advantages and disadvantages of stored procedure?

1140

What is a parameter query?

1071

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1018

How to prepare for oracle pl sql certification?

1055

What are operators available in sql?

1037

What is on delete restrict?

998

What is procedure explain with example?

950

What are pl/sql packages?

1098

What is varray in pl sql?

1067