Difference between global and parameter variables?

0 Answers   TCS,

---

What are the different types of joins and explain them briefly.

3 Answers  

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

---

How many types of triggers are there in pl sql?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

What is a unique key?

0 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---

What is database sql?

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,

---