InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Oracle Cursor : Implicit & Explicit Cursors? |
|
Answer» There are some work areas which is called private SQL. private SQL is USED by ORACLE to create the SQL STATEMENT. PL/SQL helps to identify each e=work which is used it is called Cursor. For any KIND of query which is related to returning to a single row, it is important to declare the implicit cursor. For the queries or issues that are related on returning to more than a single row, the cursor required the declaration of explicitly. There are some work areas which is called private SQL. private SQL is used by Oracle to create the SQL statement. PL/SQL helps to identify each e=work which is used it is called Cursor. For any kind of query which is related to returning to a single row, it is important to declare the implicit cursor. For the queries or issues that are related on returning to more than a single row, the cursor required the declaration of explicitly. |
|