Answer / shivaleela

Cartesian product:- It is a type of join in which the
number of rows in the result table is the product of the
number of rows in each table.It is also called as CROSS JOIN

Eg:-

SELECT * FROM A,B

or (can be writen as)

SELECT * FROM A CROSS JOIN B


if A has 10 records n B has 8 records than the output of
above query will b 80 records(10*8=80 RECORDS).

Answer / surya

Once the data is display in M*N format from two different
tables which has m rows in one table and n rows in another
table.We can called as cartesian product.

What is index? How many types of indexes?

2 Answers   HCL,

---

WHAT IS CARTESIAN PRODUCT?

2 Answers  

---

Why more redos are generated when the oracle database is in begin backup mode?

0 Answers  

---

What is cardinality?

4 Answers  

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

what are the advantages of Oracle over other databases..? please give me reply...

2 Answers  

---

types of receipts and detail desription about recipts and tables effected by receipts?

0 Answers  

---

1. What is PO rate variance gain and loss?

0 Answers   Oracle,

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

0 Answers  

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

0 Answers  

---

which one is currently in used software cmpanies.

0 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---