InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Recursive Sql? |
|
Answer» Whenever you execute an SQL statement, Oracle performs a number of tasks behind the scenes, such as PRIVILEGE CHECKS and object existence checks. It needs to execute MULTIPLE SQL statements to perform those tasks. These SQLs are called recursive SQLs. Whenever you execute an SQL statement, Oracle performs a number of tasks behind the scenes, such as privilege checks and object existence checks. It needs to execute multiple SQL statements to perform those tasks. These SQLs are called recursive SQLs. |
|