Answer / rajesh venati

Yes, we can use global variables in procedure and functions.

How to load data with sql*loader?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

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,

---

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

---

what is definer rights invoke rights?

1 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

Why indexing is needed?

0 Answers  

---

What does truncate mean in sql?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

Enlist the advantages of sql.

0 Answers  

---

What is the purpose of the sql select top clause?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---