Answer / deva

The join between tables with out any conditions specified
results in the cartesian product. Cartesian product will be
equal to the product of number of rows in the tables that
take part in the join.

Answer / deepak rathore

the cartesian product is a direct product of sets .
the cartesian product of two sets X and Y. Denoted XxY , is
the set of all possible order pair whose first components
is a member of X and whose second components is member of Y.

What is meant by redo log buffer ?

2 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

what is the difference between no rows returned and null returned?

2 Answers  

---

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

---

What is a recycle bin in oracle?

1 Answers  

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

0 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,

---

How to convert characters to numbers in oracle?

0 Answers  

---

What are the different types of synonyms?

0 Answers  

---

How to synchronize 2 schema's objects?

0 Answers   Virtusa,

---