package specification-3 procedures package body-4 procedures how can i write fo

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

Question Posted / arpitha2206

2 Answers
6819 Views
Reliance, I also Faced
E-Mail Answers

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 a variable in sql?

0 Answers

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers IAS,

How do I count records in sql?

0 Answers

Does sql use python?

0 Answers

what is the difference between the query and corelated query

8 Answers HSBC, IBM, TCS, Xenosoft,