Why is partition used in sql?

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

What sql database should I use?

0 Answers  

---

What is the difference between the conventional and direct path loads? : aql loader

0 Answers  

---

---

Can a table contain multiple foreign key’s?

0 Answers  

---

What are the different schemas objects that can be created using pl/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,

---

What is rename command in sql?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

What is a pragma statement?

0 Answers  

---