Answer Posted / vikas mohan

It is a technique for designing a database system and is a
process in which data in a single table is being replaced
into number of tables with the same data along with some key
relationships being set up among the tables.
and also reducing duplication in the database,with
the ultimate goal of eliminating duplicate data entirely.

all the best

How to use "while" statements in oracle?

1228

---

Explain the features of oracle?

988

---

What privilege is needed for a user to create views in oracle?

977

---

What is the usage of control file in oracle?

1024

---

How to view the tablespaces in the current database?

926

---

What is the dynamic sql in oracle?

1006

---

What are the original export and import utilities?

1056

---

How to insert a new row into a table in oracle?

1087

---

Explain the use of grant option in imp command.

958

---

How to loop through data rows in the implicit cursor?

1014

---

How to use "if" statements on multiple conditions?

1110

---

Is there an oracle sql query that aggregates multiple rows into one row?

930

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1694

---

Is oracle an operator?

882

---

How to define a sub function?

1082

---