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 rowtype?
How can we store rows in PL/SQL using array?
What does the argument [or replace] do?
How do you exit in sql?
Do we need to rebuild index after truncate?
What are pl/sql packages?
List the different type of joins?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What does fetching a cursor do?
Explain the working of primary key?
Which is better join or inner query?
what is the use of double ampersand (&&) in sql queries?
How do I install sql?
What is sap sql?
How do sql triggers work?