when a procedure /package is getting invalidated?

4 Answers   TCS,

---

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 error ora-01000: maximum open cursors exceeded

0 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

What is sql procedures and functions?

0 Answers  

---

---

Which is faster count (*) or count 1?

0 Answers  

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

What is the difference between a primary key and a unique key?

0 Answers  

---

What is difference between stored procedures and application procedures?

0 Answers  

---

What is fmtonly in sql?

0 Answers  

---