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;
/

How much does sql cost?

930

---

what is clause? : Sql dba

1003

---

What are all the different normalizations?

970

---

What is lookup table in sql?

980

---

What are predefined functions in sql?

977

---

Which sql most popular?

935

---

How do you change a value in sql?

965

---

Is left join inner or outer by default?

973

---

Mention what is the plv (pl/vision) package offers?

1056

---

What are % type and % rowtype?

979

---

Why trigger is used in sql?

914

---

Where is all the data on the internet stored?

948

---

What is trigger in sql? Explain

941

---

How to handle bulk data?

1269

---

What is the use of count (*) in sql?

980

---