Answer / kumari

SELECT TOP (3)with ties empsalry
FROM empsalr

order by empsalry desc;

Answer / neo devan

select max(sal) from emp having max(sal)!=(select max(sal)
from emp where max(sal)!=(select max(sal) from emp));

How to write date and time interval literals in oracle?

0 Answers  

---

What are the different types of partitions in oracle?

0 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

What are transaction isolation levels supported by oracle?

0 Answers  

---

Can we create index on views?

19 Answers   CTS, Syntel, TCS,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

0 Answers  

---

What is tns entry?

0 Answers  

---

Can a View based on another View ?

3 Answers  

---

What are cursor?where are they used?

2 Answers  

---

T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"

2 Answers   Cognizant,

---