Which of the following are restrictions to Cursor Expression?

Options
- Implicit Cursor
- view declaration
- BIND and EXECUTE operations
- All of the Above

CORRECT ANSWER : All of the Above

Discussion Board
Restrictions to Cursor Expression

The following restrictions apply to CURSOR expressions:

- If the enclosing statement is not a SELECT statement, nested cursors can appear only as REF CURSOR arguments of a procedure.

- If the enclosing statement is a SELECT statement, nested cursors can also appear in the outermost select list of the query specification or in the outermost select list of another nested cursor.

- Nested cursors cannot appear in views.

- You cannot perform BIND and EXECUTE operations on nested cursors.

Prajakta Pandit 02-20-2017 06:55 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲