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.

Is it possible to drop a column in a table which contains only one column? How?

1 Answers  

---

How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views

2 Answers   Cap Gemini, Syntel,

---

Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....

2 Answers   Ion Exchange,

---

default triggers available for reports

0 Answers  

---

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

---

what is the difference between TRUNCATE and DELETE command in SQL

23 Answers   ICICI, Saama Tech, SkyTech, TCS,

---

what is the querry to get first 10 records from the emp table?(emp no is the primary key)

4 Answers   Verizon,

---

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

0 Answers  

---

What command would you use to create a backup control file?

1 Answers  

---

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

0 Answers  

---

can we use lexical perameter in oracle plsql if yes how

0 Answers  

---

what are basic modules required to implement oracle application in any oraganisation?

0 Answers  

---