What is %rowtype in pl sql?

0 Answers  

---

How to copy a table in another table with datas?

9 Answers  

---

How do I run a query in pl sql developer?

0 Answers  

---

How to rename a table?

0 Answers  

---

What are the subsets of sql?

0 Answers  

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

Can we use distinct and group by together?

0 Answers  

---

How many rows will return from dual table?

4 Answers   Fujitsu,

---

Is join an inner join?

0 Answers  

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---

what are the types of join and explain each? : Sql dba

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,

---