Answer / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Answer / a.swarna devi

select max(sal)from table;

Answer / havyas

select sal from table where rownum = 2 order by sal desc

How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  

---

How do I know if oracle client is installed on windows?

0 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What do you mean by cdb and pdb in oracle 12c?

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

diff between DELETE and TRUNCATE?.

14 Answers   HCL, Yalamanchili Software,

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,

---

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

1 Answers  

---

List the various oracle database objects?

0 Answers  

---

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  

---

what is the use of system.effective.date variable in oracle?

0 Answers  

---

why dont we assign not null constraint as table level constraint.

0 Answers  

---