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
How to return an array from java to pl/sql?
Is sql similar to python?
How do sql triggers work?
What is rownum?
what is not null constraint? : Sql dba
Is full outer join same as cross join?
What are the steps for performance tuning.
Difference between table function and pipelined function?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is difference between pls_integer and integer?
What is a schema sql?
What is structural independence and why is it important?
What is the difference between join and natural join?
What is the difference between database trigger and stored procedure?
What is primary key secondary key alternate key candidate key?