Answer Posted / pranab kumar mishra

1.Saving the rext of the create package statement in two
different sql files facilitates latter modification to the
package.Each package is easily understood & interface
between package are simple,clear& well defined.

2.package promote code reuse through the use of library that
contain stored procedure & function.so redundent coding.

3.Hiding information.

How to return an array from java to pl/sql?

1143

---

What is scalar function?

1054

---

What is triggering circuit?

1066

---

What do you mean by stored procedures? How do we use it?

996

---

What are the string functions in sql?

976

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2500

---

How long it takes to learn pl sql?

1010

---

what are the types of subquery? : Sql dba

1105

---

What is a sql instance vs database?

1117

---

How do I view a sql trace file?

1030

---

Is there a 64 bit version of ssms?

961

---

what is query cache in mysql? : Sql dba

1036

---

what is meant by nl2br()? : Sql dba

1046

---

Explain the difference between sql and mysql.

1062

---

What are types of joins?

965

---