Oracle SQL Question:
Download Job Interview Questions and Answers PDF
What is is a cursor?
Answer:
Oracle uses work area to execute SQL statements and store processing information PL/SQL construct called a cursor lets you name a work area and access its stored information A cursor is a mechanism used to fetch more than one row in a Pl/SQl block.
Cursor is a variable.
it is similar to a 2D array .
used for processing multiple rows.
used for storing data temporarily.
Cursor is a variable.
it is similar to a 2D array .
used for processing multiple rows.
used for storing data temporarily.
Download SQL Oracle Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain What is difference between SQL and SQL*PLUS? | Explain What are various joins used while writing SUBQUERIES? |