How can we debug in PL/SQL?

0 Answers  

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

How do you define a foreign key?

0 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

What is the difference between delete and truncate commands?

0 Answers  

---

What is sqlservr exe?

0 Answers  

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---

What are system versioned tables?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

Is oracle and sql same?

0 Answers  

---

What is pl sql record in oracle?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---