Answer Posted / aravinda

package is collection of logically related pl/sql types
,items, subprograms. packages have following advantages over
procedures and functions.

Modularity, easy to design applications, information hiding,
added functionality and best performance.

we can declare global variables in packages which are valid
across application.

without invalidating the package we can modify the package body.

Can you have more than one trigger on a table?

996

---

How do you write a complex sql query?

1056

---

how to use regular expression in pattern match conditions? : Sql dba

1022

---

What are the advantages of pl sql?

1119

---

Is inner join faster than left join?

1185

---

What program will open a mdb file?

958

---

What is the purpose of using pl/sql?

1135

---

Can delete statement be rollbacked?

980

---

Is natural join same as inner join?

925

---

What are the built in functions of sql?

1026

---

How do I partition a table in sql?

1121

---

How can a function retun more than one value in oracle with proper example?

1071

---

What is a record in pl/sql?

1138

---

Can one improve the performance of sql*loader? : aql loader

1041

---

What is difference between procedure and trigger?

973

---