Answer / Sandeep Jaiswal

A .pll file (PL/SQL Library) in Oracle contains compiled PL/SQL units such as procedures, functions, packages, and types. The .pll files are used to share code between different sessions, schemas, and even databases. They help improve performance by reducing the need for repeated compilation of the same code across multiple sessions. The import utility (imp) can be used to load PL/SQL libraries from one database into another.

Is primary key indexed by default in oracle?

1 Answers  

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

What is using clause and give example?

1 Answers  

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1 Answers   NIC,

---

Can you tell me how to add new column in existing views?how?How is possible?

1 Answers   FIS,

---

How to start your 10g xe server from command line?

1 Answers  

---

What are the roles of dba?

1 Answers  

---

What is the difference between Delete, Truncate and Drop in Oracle?

1 Answers   MCN Solutions,

---

does the query needs a hint to access a materialized view?

1 Answers  

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1 Answers   Mastek,

---

How to resolve name conflicts between variables and columns?

1 Answers  

---