Answer Posted / nitin berwal

select top 1 salary from(select top 3 salary from emp order
by desc) a

Explain a segment?

1021

---

How to add a new column to an existing table in oracle?

1072

---

Where do we use decode and case statements?

945

---

How to grant create session privilege to a user in oracle?

948

---

How to load excel data sheet to oracle database

967

---

How to write a query with a left outer join in oracle?

1004

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

---

Difference between open_form and call_form in oracle.

1094

---

What are the tools for Oracle ?

1009

---

What is meant by joins? List out the types of joins.

960

---

Explain about functional dependency and its relation with table design?

954

---

How to store pictures on to the database?

923

---

What is a package in oracle?

1028

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2176

---

What is the fastest query method to fetch data from the table?

1295

---