Answer Posted / shivaprasad

Hi Every one,this query will helps you to find 1st or 2nd or
3rd or and so on salary from the employee table.

change inside distinct top (3) for respective results

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

What is the minimum client footprint required to connect c# to an oracle database?

1092

---

What the is the diff between local index and global index. give some example.

1638

---

Explain drop constraint oracle?

1060

---

Difference between varchar and varchar2 data types?

1183

---

How to add another datafile to a tablespace?

1040

---

How to create a table in a specific tablespace?

974

---

How to create a temporary table in oracle?

1267

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2204

---

What is the difference between Delete, Truncate and Drop in Oracle?

1129

---

List out the components of logical database structure of oracle database.

1035

---

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

2103

---

What are the components of logical database structure in oracle database?

1086

---

How many anonymous blocks can be defined?

1182

---

When do I need to use a semicolon vs a slash in oracle sql?

1088

---

What is an external table?

1014

---