What are the different dcl commands 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,

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

What are keys in sql?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Why do we use procedures in sql?

0 Answers  

---

What is delimiter sql?

0 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

Explain what is a field in a database and record in a database?

0 Answers  

---

What is the reports view in oracle sql developer?

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---