Write a unique difference between a function and a stored procedure.

0 Answers  

---

Does truncate require commit?

0 Answers  

---

Which sql statement is used to return only different values?

0 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 AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

Difference between truncate, delete and drop commands?

0 Answers  

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

---

what are properties of a transaction? : Sql dba

0 Answers  

---

what is the different between now() and current_date()? : Sql dba

0 Answers  

---

What is varchar data type in sql?

0 Answers  

---