What is a null value?

0 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

What is benefit of creating memory optimized table?

0 Answers  

---

What is a database trigger ? Name some usages of database trigger ?

4 Answers  

---

How do I view stored procedures?

0 Answers  

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

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  

---

State some properties of relational databases?

0 Answers  

---