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

How is a process of pl/sql compiled?

0 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

what is datawarehouse? : Sql dba

0 Answers  

---

Can we use two order by clause in query?

0 Answers  

---

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

---

how do you know the version of your mysql server? : Sql dba

0 Answers  

---

What is differance unique key and primary key.

7 Answers   EDS,

---

what is table? : Sql dba

0 Answers  

---

Can you have more than one key in a database?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Why do we need cursors in pl sql?

0 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---