Answer / Chandan Kumar Singh

"In PL/SQL, a package is a collection of related objects (procedures, functions, variables, and types) that are used to encapsulate functionality and provide modularity. Packages can be used to group related code together, enhance security by hiding implementation details, and improve reusability."

How to read/write files from pl/sql?

1 Answers  

---

What is the difference between having clause and where clause?

1 Answers  

---

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

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

How many aggregate functions are available there in sql?

1 Answers  

---

Explain autonomous transaction.

1 Answers  

---

Explain correlated query work?

1 Answers  

---

What is coalesce in sql?

1 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

how to create object in plsql

2 Answers   TCS,

---

what is foreign key? : Sql dba

1 Answers  

---

What is a full join sql?

1 Answers  

---