Answer / pavan_1981

UNION:set of all rows selected by both queries excluding
duplicates rows.
UNIONALL:set of all rows selected by both queries including
duplicate rows.
MINUS:set of all rows present in the first query and not
present in the second query.
INTERSECT:set of all rows commonly returned by both the
queries.

what is a control file ? : Sql dba

0 Answers  

---

how to get help information from the server? : Sql dba

0 Answers  

---

What are secondary keys?

0 Answers  

---

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

Can we call stored procedure in function?

0 Answers  

---

---

What is full form of rtm?

0 Answers  

---

How do I run a query in pl sql developer?

0 Answers  

---

What does data normalization mean?

0 Answers  

---

How to create an array in pl/sql?

0 Answers  

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

What are database links used for?

0 Answers  

---

What is time based sql injection?

0 Answers  

---