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 Restricted Mode of Instance Startup in Oracle?

673

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2386

---

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

1488

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1610

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1791

---

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

644

---

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

723

---

key flexfield structure

1599

---

HOW TO SPOT AHIERARCHY?

1847

---

how to replace not in with not exist?

3189

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1618

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2139

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

653

---

How would you determine what sessions are connected and what resources they are waiting for?

1610

---

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

656

---