How can you create Cursor with parametres ?
Answers were Sorted based on User's Feedback
Answer / 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;
/
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / madhuri
We can create cursor with parameters using parameterized
cursors.We declare the cursor in the deceleration section
with parameters.
Syntax: cursor <cursor_name>(parameters) is <select_stmt>
We pass values to these cursors while opening it.
open c1(100,'Computers');
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amar_kondla
HI SWAPNA, I WAS C UR EXAMPLE, BUT IN PARAMETELIZED
CURSORS PARAMETERS ALWAYS IN MODE;
Is This Answer Correct ? | 0 Yes | 0 No |
what are the advantages of package?
What are the different types of functions in sql?
How do I quit sql?
What is record variable?
Do we need to create index on primary key?
What are analytic functions in sql?
Explain the uses of database trigger.
What is cost in sql execution plan?
What sql database should I use?
What are the uses of merge?
What is the process of debugging?
What are the set operators in sql?