Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Describe the types of sub query?
What is a nvl function? How can it be used?
How to drop an index?
if you ctreate table identity
Explain what are the uses of rollback segment?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to use "in" parameter properly?
How many types of database triggers exist?
How many types of cluster table in Oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is dynamic proxy?
How to execute the package in oracle?
What is oracle in java?
