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

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

what is a table in a database ? : Sql dba

0 Answers  

---

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

---

What does pl sql stand for?

0 Answers  

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

What is multiple partition?

0 Answers  

---

Explain the working of foreign key?

0 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

How do I sort a table in sql?

0 Answers  

---