What are procedures used for?

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,

---

Why is sql*loader direct path so fast?

0 Answers  

---

Is pl sql useful?

0 Answers  

---

Can we use ddl statements in stored procedure sql server?

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What is substitution variable in pl sql?

0 Answers  

---

What are functions in sql?

0 Answers  

---

what are all the common sql function? : Sql dba

0 Answers  

---