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;

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4006

---

Can we create view in stored procedure?

955

---

What is foreign key and example?

927

---

Can we commit inside a trigger?

985

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

956

---

What are the different types of functions in sql?

1046

---

Why do we use set serveroutput on?

963

---

Which is faster subquery or join?

1205

---

What do you mean by query optimization?

996

---

What are data types in pl sql?

1134

---

what is 'mysqladmin' in mysql? : Sql dba

1024

---

When to use inner join and left join?

952

---

What is a data manipulation language?

1019

---

What are the advantages of pl sql over sql?

1021

---

What is a sql select statement?

1032

---