what is the uses of cusor
Answers were Sorted based on User's Feedback
Answer / faize
when query is executed in oracle then result set is
produced & stored in the memory.Oracle allows the
programmer to access this resultset in the memory through
cursors
two types of cursors:
1.Explict cursor
2.Implict cursor
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ace dba
The DBA who has to performance troubleshoot you code when
you do row-at-a-time processing in a set-oriented database.
Or is that curser?
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
How does oracle handle read consistency?
What are advantages of dateset in datastage?
How to open and close an explicit cursor in oracle?
How do I call oracle stored procedures that take no parameters?
How do I find my oracle client driver version?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
How to commit the current transaction in oracle?
How to assign query results to variables?
How to estimate disk space needed for an export job?
What is Trace File ?