Answer Posted / swapna

CREATE OR REPLACE procedure emp_disp1(DNO EMP.DEPTNO%TYPE)
is
CURSOR CN(DNO1 NUMBER) IS SELECT * FROM EMP WHERE DEPTNO =
DNO;
CV CN%ROWTYPE;
begin
IF CN%ISOPEN THEN
DBMS_OUTPUT.PUT_LINE('CURSOR ALREADY OPEN');
ELSE
OPEN CN(DNO);
DBMS_OUTPUT.PUT_LINE('CURSOR OPEN NOW');
END IF;
FETCH CN INTO CV;
WHILE CN%FOUND LOOP
dbms_output.put_line('employee
id'||' '||CV.EMPNO||'employee
name'||' '||CV.Ename||'employee
managerid'||' '||CV.mgr||'employee
salary'||' '||CV.sal||'eEMPLOYEE DEPT
ID'||CV.DEPTNO);
FETCH CN INTO CV;
END LOOP;
DBMS_OUTPUT.PUT_LINE('NUMBER OF FETCHES IS '||CN%ROWCOUNT);
CLOSE CN;
exception
when no_data_found then
dbms_output.put_line('record not existed');
when too_many_rows then
dbms_output.put_line('record not existed');
end;
/

What is a unique constraint?

1029

---

what is the use of friend function? : Sql dba

994

---

What are the ways on commenting in a pl/sql code?

1083

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1801

---

how to increment dates by 1 in mysql? : Sql dba

947

---

What is the use of procedures?

936

---

How do you write a subquery?

981

---

what is commit? : Sql dba

1042

---

Is sql a case sensitive language?

904

---

What is embedded sql in db2?

974

---

Which one is better subquery or joins?

1028

---

What is the difference between join and natural join?

902

---

what is clause? : Sql dba

1024

---

How to select random rows from a table?

1036

---

how does a local variable is defined using t-sql? : Transact sql

968

---