Database Administration Question: Download Database Administration PDF
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
Answer:
oracle uses private sql area to execute sql queries and store the information.pl/sql uses cursors to name these private sql area and access its stored information
there r two types of cursors
implicit
explicit
implicit cursors are used for all dml and single row queries.these are system defined
explicit cursors are used for queries which return multiple row .these are user defined.
there r two types of cursors
implicit
explicit
implicit cursors are used for all dml and single row queries.these are system defined
explicit cursors are used for queries which return multiple row .these are user defined.
Previous Question | Next Question |
Explain What is an extent? | Explain What is hash cluster? |