Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
Submitted by: Administratororacle 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Database Administration Job Interview Questions And Answers
Top Database Administration Questions
☺ | What are the types of synonyms in Oracle? |
☺ | What is Parallel Server in Oracle? |
☺ | Explain Can we decrease the Datafile size? |
☺ | Explain database clusters? |
☺ | Explain What is a database instance? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |