What do you mean by stored procedures? How do we use it?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

What is multiple columns?

0 Answers  

---

How can triggers be used for the table auditing?

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,

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

What is a unique key and primary key and foreign key?

0 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---