What is a system versioned table?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

What is a loop 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 are rollup and cube in t-sql? : Transact sql

0 Answers  

---

---

can i give user defined exception in a package

2 Answers  

---

Is sql a scripting language?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

How do you know if a relationship is 2nf?

0 Answers  

---

What is a left join?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

Determine if oracle date is on a weekend?

0 Answers  

---