Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

What is the advantage of nosql?

0 Answers  


How can you select unique records from a table?

0 Answers  


A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,


what are enums used for in mysql? : Sql dba

0 Answers  


is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,






what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,


What is pl/sql tables?

7 Answers   TCS,


Explain exception handling in pl/sql?

0 Answers  


in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  


What does data normalization mean?

0 Answers  


What does pl sql stand for?

0 Answers  


What is column?

0 Answers  






Categories