package specification-3 procedures
package body-4 procedures how can i write for other
procedure in package body

Answers were Sorted based on User's Feedback



package specification-3 procedures package body-4 procedures how can i write for other procedure i..

Answer / 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

package specification-3 procedures package body-4 procedures how can i write for other procedure i..

Answer / rajasekhar

The 4th procedure have to declare and implement in the body.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how to insert the records in particular position

1 Answers  


What is the need of a partition key?

0 Answers  


what are string data types? : Sql dba

0 Answers  


How can we overcome recursive triggers in SQL?

1 Answers   iFlex,


What is dynamic sql in pl sql?

0 Answers  






I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,


What does data normalization mean?

0 Answers  


What is the basic structure of PL/SQL ?

6 Answers  


What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,


what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  


What is a stored procedure ?

5 Answers  


What do you understand by case manipulation functions?

0 Answers  


Categories