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.

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

---

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers  

---

What Are Cross Validation & Adi?

0 Answers   Oracle,

---

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

0 Answers  

---

How would you force a log switch?

1 Answers  

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  

---

what is difference between inner join & nested query or subqueries

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

0 Answers  

---

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

0 Answers  

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---