Latest Answer : Cursor is a private Sql area which is used to execute sql statements and store Processing information, Where as Refcursor is a data structure which points to an object which inturn points to memmory LocationThe advantage Refcursor over Normal Cursor is1.We ...
Latest Answer : By using cursor parameters we can pass the value dynamically. So that cursor can fetch data as per parameter ...
What is cursor? Explain the types of cursor and write one implicit cursor program to check how many records deleted from table?
Hi, in Cursors this is the Scenario.if i am manipulating the data of a table which has 10 records,i need to go to the 5th record.how is it possible?What is the Exact usage of Ref Cursor?
Latest Answer : Ref cursor is like a pointer to the cursor variable which is opened at the servecr side and pass the data as a whole and not one by one . ...
Latest Answer : Yes you can pass the whole select statement of the cursor dynamicaly, see ref_cursors.There is also a system package sys.dbms_sql which allows everything to make dynamically. ...
I have written a procedure in which the cursor is fetching 2 lakh records. I would like to pass on these 2 lakh records as an in paramter to the other procedure. How can we achieve this logic?
Latest Answer : Hi Friend! If you deal with better performance You have to refer REF CURSOR and its more advantage and effecient of Exeqution.Thanks&RegdsRamki ...
What would be the o/p for this ....declarecursor c1 is select * from employees;emp_rec c1%rowtype;beginopen c1;delete from employees;loopfetch c1 into emp_rec;exit when c1%notfound;end loop;close c1;end;tell me what is active set ?why you need cursors?and what is going to happen when you use for update clause in cursor declarationwhy use nowait clause what is its use
1.what is difference between pl/sql table and records?2. what is the advantages of pl/sql table?3. what is ref cursor? what is the advantages of ref cursor
