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
What is offset and limit in sql?
How is use pl and sql?
What is embedded sql in db2?
what are numeric data types? : Sql dba
What is sql and its types?
What is sql and db2?
What are the types of keys?
What are the different sql commands?
what is the syntax for using sql_variant_property? : Transact sql
What is java sql driver?
How to add a column ‘salary’ to a table employee_details?
What is the difference between microsoft sql and mysql?
What is the difference between having and a where in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Can we commit in trigger?