what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---

How can we debug in PL/SQL?

0 Answers  

---

What is ttitle and btitle?

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

---

How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,

---

What view means?

0 Answers  

---

Can we alter stored procedure?

0 Answers  

---

Define commit?

0 Answers  

---

Which is better cte or subquery?

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

Does view contain data?

0 Answers  

---