Answer Posted / gaurav agrawal

Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. Normalization usually
involves dividing a database into two or more tables and
defining relationships between the tables. The objective is
to isolate data so that additions, deletions, and
modifications of a field can be made in just one table and
then propagated through the rest of the database via the
defined relationships.

How to view all columns in an existing table?

875

---

How to turn on or off recycle bin for the session?

1037

---

What are the varoius components of physical database structure of oracle database?

946

---

What is oracle rowcount?

1037

---

What are the set operators union, union all, minus & intersect meant to do?

939

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3275

---

What are data pump export and import modes?

1018

---

How to open and close an explicit cursor in oracle?

1002

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5333

---

What is the best way to do multi-row insert in oracle?

1014

---

What is columnar storage what is the advantage?

985

---

Why cursor variables are easier to use than cursors?

1022

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

---

Explain a synonym?

971

---

Will you be able to store pictures in the database?

1063

---