Answer / Mithilesh Kumar Pandey

A substitution variable in PL/SQL is a placeholder for dynamic data during the execution of a script. It allows you to insert values into SQL statements at runtime, making scripts more flexible and reusable. They are denoted by two consecutive ampersands (&), followed by the name of the variable. For example: &my_variable.

What are sql constraints?

1 Answers  

---

How many subqueries can be nested in a statement?

1 Answers  

---

what is sql profiler? : Sql dba

1 Answers  

---

Why we use sql profiler?

1 Answers  

---

What is the use of stored procedures?

1 Answers  

---

What is numeric function sql?

1 Answers  

---

What is cursor and why it is required?

1 Answers  

---

What version is sql?

1 Answers  

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1 Answers  

---

What is a left inner join?

1 Answers  

---

What is type and rowtype in pl sql?

1 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---