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 can you enable a trace for a session?

2 Answers  

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

key flexfield structure

0 Answers   Infosys,

---

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

0 Answers  

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

0 Answers  

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers  

---

1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count

3 Answers   HP,

---

the user should know to which database he is connected currently in oracle

3 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,

---

what are the API of GL,PO,AP

0 Answers  

---

I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

0 Answers   Polaris,

---