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.

Answer / rajasekhar

The 4th procedure have to declare and implement in the body.

What are the advantages of pl sql?

0 Answers  

---

Which one is faster ienumerable or iqueryable?

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

when normalization is required

3 Answers   HCL,

---

Does sap use sql?

0 Answers  

---

How do I add a database to sql?

0 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

How do I save the results of sql query in a file?

0 Answers  

---

Which table is left in left join?

0 Answers  

---