Answer Posted / akn

Inner join is the most common type of join. Inner joins
return all rows from multiple tables where the join
condition is met.

Outer join returns all rows from one table and only those
rows from a secondary table where the joined fields are
equal (join condition is met).

How to define a record variable to store a table row?

1001

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4111

---

What is a static data dictionary in oracle?

1021

---

Calculate difference between 2 date / times in oracle sql?

985

---

How to define an oracle sub procedure?

1046

---

What is a trace file and how is it created in oracle?

970

---

Explain alias?

1076

---

What is index in Oracle?

1005

---

What happens if the update subquery returns multiple rows?

1037

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1055

---

Explain the use of grant option in exp command.

1002

---

What is a system tablespace and when it is created?

916

---

How to store pictures on to the database?

919

---

How to change system global area (sga) in oracle?

957

---

What are the different types of partitions in oracle?

906

---