Answer / a g srikanth

Any procedure that is declared and defined ONLY in the
package body is a private procedure. This procedure is
local to the package and other procs cannot call any
private procedure.

On the other hand if the procedure is defined in the
package specification and defined in the package body it is
a public procedure, this is accessible to other procs also.

Answer / siva

If the procedure is with in the package it is the public
procedure,other wise it is private procedure.

Answer / swati sucharita

private procedure is used before class name.if we have
declared private before class name then subclass cannot
inherit the properties of private class.
public procedure is used before class name,if we have
declared public before class name then all other class can
inherit the properties of public class.

What is the difference between union and union all command?

0 Answers  

---

What is meant by Materialized view?

2 Answers   iGate, Marlabs, Polaris,

---

What is nvarchar in sql?

0 Answers  

---

How to avoid using cursors?

0 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What is difference between table and view?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

What is parallel hint?

0 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---