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

Do ddl statements need commit?

978

---

Can I learn sql in a week?

1086

---

How do you get column names only for a table (sql server)?

1174

---

what is oltp (online transaction processing)? : Sql dba

1087

---

what are the difference between clustered and a non-clustered index? : Sql dba

1037

---

What is procedure and function?

999

---

What is difference between sql function and stored procedure?

1013

---

What's the difference between inner join and left join?

1008

---

Write the command to remove all players named sachin from the players table.

1188

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1601

---

What is cascade in sql?

967

---

How can a function retun more than one value in oracle with proper example?

1086

---

What is cursor and why it is required?

1190

---

Why do you partition data?

1028

---

Explain what is a database?

1091

---