Answer Posted / prabhudatta barick

CREATE OR REPALCE PROCEDURE EMP_PRO
IS
BEGIN

FOR EMP_CUR IN(SELECT SUBSTR(EMP_DOA,4,3) MONTH,
COUNT(*) NO_OF_EMP
FROM HRD_EMPLOYEETB
GROUP BY SUBSTR(EMP_DOA,4,3)
ORDER BY 1)
LOOP

DBMS_OUTPUT.PUT_LINE(EMP_CUR.MONTH||' '||EMP_CUR.NO_OF_EMP);


END LOOP;

END;

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1197

---

how to include comments in sql statements? : Sql dba

962

---

What can I use instead of union in sql?

970

---

Is sql port 1433 encrypted?

1031

---

Can we use threading in pl/sql?

1043

---

Is and as keyword in pl sql?

963

---

Are subqueries faster than joins?

1024

---

tell us something about heap tables. : Sql dba

1104

---

What does seeding a database mean?

973

---

Is microsoft sql free?

1107

---

What is the use of nvl function?

1201

---

Why do we need cursors in pl sql?

1090

---

Can you upgrade sql express to full sql?

1075

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1038

---

How does rowid help in running a query faster?

1419

---