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


Please Help Members By Posting Answers For Below Questions

What is rowtype?

573


How can we store rows in PL/SQL using array?

670


What does the argument [or replace] do?

586


How do you exit in sql?

597


Do we need to rebuild index after truncate?

529






What are pl/sql packages?

575


List the different type of joins?

575


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

625


What does fetching a cursor do?

621


Explain the working of primary key?

614


Which is better join or inner query?

523


what is the use of double ampersand (&&) in sql queries?

629


How do I install sql?

524


What is sap sql?

540


How do sql triggers work?

556