Answer Posted / kamala k n

select * from (select ename,sal,rank() over(order by sal desc) as ranks from emp)
where ranks=2;

Can you create a synonym without having a table?

642

---

Explain the features of oracle?

683

---

Explain drop constraint oracle?

659

---

How to define a data source name (dsn) in odbc manager?

607

---

How to import one table back from a dump file?

685

---

---

What privilege is needed for a user to query tables in another schema?

597

---

Is oracle a programming language?

650

---

Can a parameter be passed to a cursor?

697

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2126

---

What is an Oracle Instance?

765

---

What is java oracle used for?

627

---

How to best split csv strings in oracle 9i?

685

---

Explain the use of rows option in imp command.

677

---

Name the three major set of files on disk that compose a database in Oracle?

714

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4573

---