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.

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  

---

How do you resize a data file?

2 Answers  

---

3. Steps in UAT?

0 Answers   Oracle,

---

What is the difference between recovery and restoring of the oracle database?

0 Answers  

---

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

---

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

---

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

0 Answers   HCL,

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

as a technical developer in oracle applications which type errors feced in your experience sofar

0 Answers   HCL,

---