Answer / Ashish Babu

PL/SQL (Procedural Language/SQL) is a procedural extension of SQL and is used in Oracle Database to create stored procedures, functions, packages, triggers, and other programmatic elements. It allows developers to create reusable code that can perform complex operations, handle errors, manage transactions, and maintain state between SQL statements.

What is a sql*loader control file?

1 Answers  

---

How do I tune a sql query?

1 Answers  

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

What is a temp table?

1 Answers  

---

What is union and union all keyword in sql and what are their differences?

1 Answers  

---

What are % type and % rowtype?

1 Answers  

---

How do I edit a stored procedure?

1 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

What does an inner join do?

1 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---