Answer Posted / 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 |
Post New Answer View All Answers
How to fetch the row which has the max value for a column?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the ways tablespaces can be managed and how do they differ?
How to use subqueries in the from clause in oracle?
What is a table index in oracle?
Explain the features of oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Which environment variables are absolutely critical in order to run the OUI?
What is a select query statement in oracle?
how to handle exceptions in post production
How to pass a parameter to a cursor in oracle?
How to define an anonymous procedure without variables?
How do we display rows from the table without duplicates?
How to store only time; not date and time?
What is control file used for?