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).

TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3555

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1763

---

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

2168

---

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

2702

---

What is supporting issues GL AP and AR?

2519

---

Can we modify approve purchase order?if yes what is navigation?

1998

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1070

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2398

---

What is the disk migration? what is the steps involved in oracle disk migration?

1209

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2358

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2054

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1248

---

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

1320

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2382

---

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

2215

---