TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

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 sql not null constraint?

0 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

---

What are the two parts of design view?

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

---

What are joins in sql?

0 Answers  

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

What is the difference between drop and truncate commands?

0 Answers  

---

Can you inner join the same table?

0 Answers  

---