Answer / Tannu Singh

Yes, you can commit inside a PL/SQL trigger to permanently save changes made by the trigger. However, this is not usually necessary as the trigger's commit or rollback behavior typically follows that of the parent transaction.

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

What is numeric function sql?

1 Answers  

---

How do you update a value in sql?

1 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1 Answers  

---

Explain the the update statement in sql?

1 Answers  

---

How exception is different from error?

1 Answers  

---

What is the syntax and use of the coalesce function?

1 Answers  

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

what is a database lock ? : Sql dba

1 Answers  

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1 Answers  

---

What is parameter substitution in sql?

1 Answers  

---