Answer Posted / 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).

What is chargeback invoice? How do we create it? : oracle accounts receivable

1041

---

default triggers available for reports

1974

---

can we use lexical perameter in oracle plsql if yes how

2073

---

What view would you use to determine free space in a tablespace?

2008

---

What are different types of transactions in ar? : oracle accounts receivable

995

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4179

---

What is the difference between conversions and interfaces? : oracle accounts receivable

889

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2003

---

How would you determine who has added a row to a table?

2034

---

please send me oracle pl/sql exp resume. and also faqs...

2270

---

What is Tax Categories?

1832

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

899

---

Difference between negative and positive adjustments : oracle accounts receivable

827

---

What is auto invoicing? : oracle accounts receivable

858

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1862

---