Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

Where do you use decode and case statements?

0 Answers  

---

Explain the use of tables option in exp command.

0 Answers  

---

How can Oracle users be audited?

0 Answers   MCN Solutions,

---

find out first highest salary?

10 Answers   Verinon Technology Solutions,

---

What do you mean by merge in oracle and how can we merge two tables?

0 Answers  

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

What happens in oracle commit?

0 Answers  

---

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers  

---

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?

0 Answers  

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---

Difference between cartesian join and cross join?

0 Answers  

---