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 do you mean by Oracle MEDIA RECOVERY?

1227

---

How would you go about increasing the buffer cache hit ratio?

2601

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

1221

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2189

---

Are These Dff's Flexible?

1171

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1347

---

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.

2193

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2070

---

can we use lexical perameter in oracle plsql if yes how

2315

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1048

---

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

1120

---

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

1299

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2134

---

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

2320

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

---