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 the Symbol use for Inner Join

1 Answers   Oracle, TCS,

---

Explain the difference between a data block, an extent and a segment.

1 Answers   Accenture, IBM,

---

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

0 Answers  

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  

---

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

0 Answers  

---

what is different between inline query,subquery& corelated query?

8 Answers   Quest,

---

How can you rebuild an index?

1 Answers  

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

0 Answers  

---

pl help me, i want oracle HRMS training institute address,in chennai

8 Answers  

---

Name two files used for network connection to a database.

1 Answers  

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

0 Answers   Logisoft,

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---