Answer Posted / manoj

select salary from emp
where salary = (select max (salary) from emp
where salary < (select max (salary) from emp
where salary < (select max (salary) from emp)));

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

1005

---

How to use "startup" command to start default instance?

962

---

How can you use check constraints for self referential integrity?

914

---

How to create a table index?

1059

---

How to connect ms access to oracle servers?

944

---

What is oracle update statement with inner join ?

991

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2245

---

What is the use of file param in imp command?

1113

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1287

---

How to connect the oracle server as sysdba?

1008

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2186

---

How to define a data field as not null?

1059

---

how to join query for one source type is oracle another source type is sql server ?

2376

---

What are the varoius components of physical database structure of oracle database?

942

---

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1954

---