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.

How to load data with sql*loader?

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

How we can update the view?

0 Answers  

---

What is data type in sql?

0 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

What is difference between inner join and cross join?

0 Answers  

---

Explain the difference between rename and alias?

0 Answers  

---

What are joins in sql?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What are the commands used in sql?

0 Answers  

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---