What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?
Answer Posted / tulsi
A cursor declared in a package specification is global and
can be accessed by other procedures or procedures in a
package.
A cursor declared in a procedure is local to the procedure
that can not be accessed by other procedures.
| Is This Answer Correct ? | 40 Yes | 2 No |
Post New Answer View All Answers
What is group by in sql?
Mention what does plv msg allows you to do?
What is the largest value that can be stored in a byte data field?
Explain mutating table error.
Is pl sql and postgresql same?
What is fmtonly in sql?
What is consistency?
What is a join query?
How to rename a column in the output of sql query?
What is prepared statement in sql?
What is the use of double ampersand (&&) in sql queries? Give an example
Explain the select statement in sql?
What packages(if any) has oracle provided for use by developers?
Which normal form is best?
What is the difference between the implicit and explicit cursors?