What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---

What does t sql mean?

0 Answers  

---

How do you update sql?

0 Answers  

---

Explain mutating table error.

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is union, minus and interact commands?

0 Answers  

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

What is %type in pl sql?

0 Answers  

---

What are the parts of a basic sql query?

0 Answers  

---

What does select * from mean in sql?

0 Answers  

---

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,

---