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 write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

0 Answers  


Is time a data type in sql?

0 Answers  


How to get help at the sql prompt?

0 Answers  


Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  


How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,






What is a trigger in sql?

0 Answers  


What is structural independence and why is it important?

0 Answers  


What are all the different normalization?

0 Answers  


What are stuff and replace function?

0 Answers  


If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,


Explain the order of sql statement execution?

0 Answers  


How much does sql certification cost?

0 Answers  


Categories