Answer Posted / somashekhar m

Union : The union operator combines the results of two or
more queries into a single result set. But no.of columns
must match in both/all the queries (and also the order)
which are used for union.
Union -- returns with no duplicate rows
Union all -- retruns with duplicate rows (No. of rows
returned = No. of rows in Query1 + No. of rows in Query 2)
Union is a set operator.
You cannot use the union operator within a create view
statement.

You cannot use the union operator on text and image columns.

You cannot use the for browse clause in statements
involving the union operator.

Joins: Joins are used to extract information from more than
one table based on the related column/coloums (PK and RFK)
any no. of rows can be retrived based on matching matching
colums. Different types of joins are Inner join=equi join=
join, outer join(Right outer join/right join, Left outer
join/ left join), Cross join, and full outer join/outer join

How to return multiple rows from the stored procedure?

968

---

What is a record in a database?

1062

---

Why is a trigger used?

939

---

Explain normalization and what are the advantages of it?

952

---

How does join work in sql?

1009

---

Can we create foreign key without primary key?

983

---

What is hibernate and its relation to sql?

1119

---

How many functions are there in sql?

1016

---

What is the difference between numeric and autonumber?

996

---

What is record in pl sql?

1083

---

What is file based approach?

941

---

how many ways to get the current time? : Sql dba

1005

---

What are the dml statements?

1141

---

What is the use of pl/sql table?

1064

---

What is sql engine in oracle?

987

---