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.

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

0 Answers  

---

You have just compiled a PL/SQL package but got errors, how would you view the errors?

1 Answers  

---

What is mrc and what is its use? : oracle accounts receivable

0 Answers  

---

Are These Dff's Flexible?

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  

---

---

Could you please let me know the interfaces in OM / FA??

0 Answers   Oracle,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

0 Answers  

---

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

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

0 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---