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 |
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How to connect the oracle server as sysdba?
How to assign a table row to a record variable?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
What is Parallel Server ?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
What is materialized view in Oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is raw datatype?
Can we save images in a database and if yes, how?
What are the benefits of ordbms?