Answer Posted / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

What are temporal data types in oracle?

598

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558

---

is there a tool to trace queries, like profiler for sql server?

608

---

What are the types of trigger in oracle?

576

---

What is oracle update statement with inner join ?

585

---

---

How to start your 10g xe server from command line?

548

---

State some uses of redo log files?

567

---

Explain a synonym?

606

---

Is rowid unique in oracle?

530

---

What is the exact use of Collections?

1682

---

What are the differences between lov and list item?

559

---

What is a lookup table in oracle?

542

---

Explain the use of constraints option in exp command.

566

---

Can we call procedure inside function in oracle?

613

---

Explain oracle 12c new features for developers?

540

---