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

Explain table and field in sql?

0 Answers  


What is the difference between distinct and unique in sql?

0 Answers  


what is sql profiler

2 Answers   Fidelity,


what is a database transaction? : Sql dba

0 Answers  


Does sql use python?

0 Answers  






Why does %isopen return false for an implicit cursor?

1 Answers  


What is trigger explain it?

0 Answers  


What is the difference between sql and isql*plus?

0 Answers  


How can I create a table from another table without copying any values from the old table?

8 Answers  


Can I call a procedure inside a function?

0 Answers  


How do I truncate a sql log file?

0 Answers  


What is a natural join?

0 Answers  


Categories