Answer / tulsi

The two parts of package are PACKAGE SPECIFICATION &
PACKAGE BODY.

Package Specification contains declarations that are global
to the packages and local to the schema.
Package Body contains actual procedures and local
declaration of the procedures and cursor declarations

Answer / senthil kumars

Package Contains Two Parts.They Are

*Package Spec
*Package Body

Package Spec contains declarations of procedures,functions
Where as Package Body Contains definitions for the
procedures and functions which r declared in the spec. Also
it contains the local variables which r to be used in the
procedure or function

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

Can we call a function containing dml statements in a select query?

0 Answers  

---

Are stored procedures compiled?

0 Answers  

---

What are the syntax and use of the coalesce function?

0 Answers  

---

function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,

---

What is example of database?

0 Answers  

---

How does a covering index work?

0 Answers  

---

What are the indexing methods?

0 Answers  

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---