What is compilation error in pl sql?

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 is the purpose of the partition table?

0 Answers  

---

What is record data type?

0 Answers  

---

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

---

---

What are the two characteristics of a primary key?

0 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

Why is sql important?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

What is the use of index in sql?

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---