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.

How do you resize a data file?

2 Answers  

---

default triggers available for reports

0 Answers  

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

How do you add a data file to a tablespace?

1 Answers  

---

Describe the P2P cycle ?

1 Answers  

---

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

0 Answers  

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

0 Answers  

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

0 Answers   HP,

---

Give two methods you could use to determine what DDL changes have been made.

1 Answers  

---

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  

---