Answer Posted / vishal

Here is the correct query:

select ename,sal from emp e
where 3 = (select count(distinct(sal))+1 from emp
where e.sal < sal);

What are the logical operations?

1125

---

How to check your oracle database 10g xe installation?

986

---

How can you use check constraints for self referential integrity?

969

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2321

---

How to load data through external tables?

1135

---

How to invoke the original export import utilities?

1062

---

What is Segment Advisor in Oracle?

1101

---

How to check the oracle tns settings?

1045

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

---

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 a view and how is it different from a table?

1044

---

How do I limit the number of rows returned by an oracle query after ordering?

1168

---

How to view the tablespaces in the current database?

978

---

Why does oracle 9i treat an empty string as null?

1054

---