Answer Posted / rajeevgeu

select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1436

---

Is oracle a relational database?

520

---

how to join query for one source type is oracle another source type is sql server ?

1989

---

Can objects of the same schema reside in different tablespace?

584

---

How a tablespace is related to data files?

581

---

---

Explain rename?

549

---

What are the types of partitions in oracle?

538

---

What operating systems are supported by oracle database 10g xe?

581

---

How to create id with auto_increment on oracle?

545

---

What are the differences between blob and clob in oracle?

580

---

How to use fetch statement in a loop?

553

---

How to retrieve data from an explicit cursor?

557

---

Can we store pictures in the database and if so, how it can be done?

587

---

definition of cluster and non-clustered index?

2475

---

How to call a stored function in oracle?

572

---