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 normalization in sql?

1020

---

What is identity column in sql server?

1054

---

what is 'mysqlshow'? : Sql dba

1032

---

What is the difference between sum and count in sql?

990

---

How to display the current date in sql?

1083

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1099

---

What is fmtonly in sql?

1090

---

Can %notfound return null after a fetch?

1063

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2150

---

define sql insert statement ? : Sql dba

1034

---

What is varray in pl sql?

1081

---

Which function is used to return remainder in a division operator in sql?

1147

---

How do I remove all records from a table?

1081

---

What are the two types of exceptions in pl/sql?

1053

---

What does count (*) mean?

936

---