How do I run a script in sql developer?

0 Answers  

---

Are dml statements autocommit?

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

What is data definition language?

0 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

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,

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

What are functions in sql?

0 Answers  

---

Why do we use procedures in pl sql?

0 Answers  

---

what is sql in mysql? : Sql dba

0 Answers  

---