What is difference between inner join and self join?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What is auto increment feature in sql?

0 Answers  

---

How to recompile a already made trigger?

2 Answers  

---

What is schema in sql?

0 Answers  

---

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

Is sql workbench free?

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

What is difference between % ROWTYPE and TYPE RECORD ?

2 Answers  

---

Why do we need unique key in a table?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---