How do I run a program in pl sql?

0 Answers  

---

What is set transaction?

0 Answers  

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

Explain the rollback statement?

0 Answers  

---

---

What is Difference Between delete and Truncate?

9 Answers  

---

What is the syntax to add a record to a table?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

Is a table valued function object?

0 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What are all the different types of indexes?

0 Answers  

---