Answer / tulsi

Raise_application_error is a procedure of package
DBMS_STANDARD which allows to issue an user_defined error
messages from stored sub-program or database trigger.

Can we use insert statement in function?

0 Answers  

---

What is full join?

0 Answers  

---

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

What is pl sql script?

0 Answers  

---

---

What are the types of dbms?

0 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

How to handle bulk data?

0 Answers  

---

What is inner join in sql?

0 Answers  

---

What is rowtype?

0 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---