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 pl sql procedure have a return statement?

956

---

Explain the difference between drop and truncate commands in sql?

957

---

What is the most important ddl statements in sql are?

941

---

What is scalar data type in pl sql?

1018

---

What is sql architecture?

980

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1000

---

How can we debug in PL/SQL?

1089

---

How to run sql functions in pl/sql?

986

---

Explain dml and ddl?

919

---

how to convert character strings to numeric values? : Sql dba

1023

---

what is the difference between truncate and drop statements? : Sql dba

1030

---

Can a procedure in a package be overloaded?

981

---

Why do we use joins in sql?

907

---

Is there any restriction on the use of union in embedded sql?

1099

---

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

935

---