What is embedded sql in db2?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

what is the use of friend function? : Sql dba

0 Answers  

---

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---

What is the difference between anonymous block and named block or stored procedure?

8 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 are the authentication modes in sql server? : Sql dba

0 Answers  

---

How do we tune the code?

2 Answers  

---

What is a primary key sql?

0 Answers  

---

What is the difference between left outer join and left join?

0 Answers  

---