Answer Posted / shiv prakash

select salary from(select rownum as r,salary from(select
rownum,salary from emp order by salary
desc))where r=2;

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

922

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2071

---

How to change user password in oracle?

975

---

How to shutdown your 10g xe server?

1090

---

Give the various exception types.

949

---

What is the difference between substr and instr?

980

---

What is meant by an index?

1062

---

what is the difference between restoring and recovering?

968

---

How will you differentiate between varchar & varchar2?

994

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2077

---

What is ceil and floor in oracle?

1013

---

What are privileges and grants?

1005

---

What is merge statement used for?

974

---

what is normalisation?what are its uses?

2215

---

How to check the server version in oracle?

1037

---