what is the uses of cusor

Answer Posted / kiran

it is the temporary space developed by the oracle server
when in an implicit cursor

and when a user wants to create a cursor then it is called
explicit cursor

so - any temporary place generated in the temporary memory
during the execution of sql query is called cursor

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of record length option in exp command.

554


Write a trigger example in oracle?

570


How to write date and time interval literals in oracle?

568


What is the meaning of recursive hints in oracle?

530


What is the difference between primary key and unique key and foreign key in oracle?

544






what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1693


What is the database name in oracle?

532


How to use "if" statements on multiple conditions?

717


What is a view and how is it different from a table?

568


Can objects of the same schema reside in different tablespace?

584


What privilege is needed for a user to query tables in another schema?

502


How would you go about verifying the network name that the local_listener is currently using?

1602


How to store pictures on to the database?

526


How to apply filtering criteria at group level in oracle?

581


How do I limit the number of oracle database connections generated by weblogic server?

543