What are different types of queries in sql?

0 Answers  

---

What is varchar example?

0 Answers  

---

How do you truncate?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

0 Answers  

---

---

What are the types pl/sql code blocks?

0 Answers  

---

How do I add a primary key to a table?

0 Answers  

---

Can sql function call stored procedure?

0 Answers  

---

what is difference between decode and case function?

2 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What are the advantages of pl sql?

0 Answers  

---