Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / arpitha2206

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 convert dates to character strings? : Sql dba

0 Answers  

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

Is left join faster than join?

0 Answers  

What is pragma in pl sql?

0 Answers  

What kind of join is join?

0 Answers  

What is procedure in pl sql?

0 Answers  

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

Explain the the update statement in sql?

0 Answers  

what are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

how to write utl file pkg in SQL

1 Answers   Oracle,

What are records give examples?

0 Answers  

Can you inner join the same table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories