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 do I count rows in sql query?

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

What are different clauses used in sql?

0 Answers  

---

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

How do you explain an index number?

0 Answers  

---

Explain unique key in sql.

0 Answers  

---

discuss about myisam index statistics collection. : Sql dba

0 Answers  

---

What are the advantages of pl sql?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

0 Answers  

---