package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body
Answer Posted / athilakshmi
Package Spec contains 3 procedures which is defined in the
Package Body. Those Procedures are Global.
If you want to add the 4th procedure, that to you want to
use as a local in the package, then no need to declare in
the Package Spec. directly you can declare and defined in
the package body itself.
if you want to use that 4th procedure as a global, then
you have to declare in the package specification.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to execute a stored procedure?
Why do we use partitions in sql?
Can a composite key be null?
What are the qualities of 2nf?
What is benefit of creating memory optimized table?
What is the use of partition by in sql?
What is PL/SQL Records?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
When you have to use a default "rollback to" savepoint of plvlog?
What is cursor in pl sql with examples?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What is the left table in sql?
Why are sql stored procedures used?
What is int identity in sql?
Can we use view in stored procedure?