What are the usage of SAVEPOINTS?

5 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

what is 'trigger' in sql? : Sql dba

0 Answers  

---

What is the difference between sql, mysql and sql server?

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 do I make sql search faster?

0 Answers  

---

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

How do I create a memory optimized filegroup?

0 Answers  

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

How do you optimize a stored procedure query?

0 Answers  

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

0 Answers   TCS,

---