Answer Posted / sanil

select first_name,salary from employees a
where (select count(distinct(salary)) from employees aa
where a.salary<=AA.SALARY) = &n;

What do you mean by a database transaction & what all tcl statements are available in oracle?

549

---

How to increment dates by 1 in oracle?

557

---

what is the difference between substr and instr function in oracle?

583

---

What is a trigger oracle?

561

---

How to rename an index?

587

---

---

How to bring a tablespace online?

518

---

Explain a private synonyms?

632

---

various types of hints and their usage

2131

---

How many types of tables supported by oracle?

578

---

How to connect to oracle using service name instead of sid?

547

---

What are the different types of failures that occur in Oracle database?

596

---

What is meant by joins?

621

---

What are the restrictions on external table columns?

547

---

How to create a stored procedure in oracle?

573

---

What is the dynamic sql in oracle?

593

---