Which software is used for pl sql programming?

0 Answers  

---

What is parallel hint?

0 Answers  

---

How do you write an index?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

Does oracle roll back the transaction on an error?

0 Answers  

---

How do I count records in sql?

0 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is sql server and ase?

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

Is a table valued function object?

0 Answers  

---