Answer Posted / guneetinder singh

it is the resultant relation from the two relation in the
sense that every element of first column in first table is
linked with every element of second relations first column.
E.G.
A={1,2}
b={3,4}
Cartesian product is = {(1,3)(1,4)(2,3)(2,4)}

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1439

---

Explain the use of indexes option in imp command.

1262

---

How to do clean up if create database failed?

1068

---

What is a cursor and what are the steps need to be taken?

1287

---

What are the data types in oracle?

1096

---

How to use subqueries with the in operator using oracle?

1137

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2441

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1894

---

What are the different types of trigger and explain its various uses and functions?

1167

---

How to check the server version in oracle?

1141

---

What is flashback in Oracle?

1063

---

What is the meaning of recursive hints in oracle?

1098

---

How to rename an index in oracle?

1170

---

Explain the use of consistent option in exp command.

1140

---

List the various oracle database objects?

1111

---