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 does count (*) do in sql?

0 Answers  


What is execute immediate?

0 Answers  


define sql insert statement ? : Sql dba

0 Answers  


What are different categories of sql commands?

0 Answers  


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  






What is %rowtype in pl sql?

0 Answers  


Define a temp table?

0 Answers  


Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  


What is replication id?

0 Answers  


What is row_number () in sql?

0 Answers  


Can a table have two primary keys?

44 Answers   HCL, MetaCube,


What is the size of partition table?

0 Answers  


Categories