what is self join and what is the requirement of self join? : Sql dba

0 Answers  

---

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

---

what is self join and why is it required? : Sql dba

1 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,

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is recursive join in sql?

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---

Give the structure of the function ?

2 Answers  

---

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

0 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

What does a pl/sql package consist of?

0 Answers  

---