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 the difference difference between procedure and packages
Is and as keyword in pl sql?
Why schema is used in sql?
What are triggers and its uses?
Does execute immediate commit?
Does access use sql?
write an sql query to find names of employee start with 'a'? : Sql dba
Do we need commit after truncate?
what is table? : Sql dba
What is sql clause?
Is sql a oracle?
discuss about myisam index statistics collection. : Sql dba
How many disk partitions should I have?
What are system versioned tables?
What is data abstraction in sql?