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

Explain character-manipulation functions?

852


what is the difference between cluster and non cluster index? : Sql dba

739


i have some prob lem to tell me about my self in interview first round ...

1902


how to see the create table statement of an existing table? : Sql dba

753


What are the types of keys?

679


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

769


What are the rules to be applied to nulls whilst doing comparisons?

1007


What does count (*) mean in sql?

1302


What is an inconsistent dependency?

771


Why do we need a foreign key?

772


What are the set operators in sql?

784


What is string data type in sql?

737


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

903


Is natural join and inner join same?

668


How many developers work on postgresql?

742