Answer Posted / jainish

select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1559

---

Explain oracle 12c new features for developers?

532

---

How to use "for" statements in oracle?

585

---

What are the execution control statements?

605

---

Explain the use of consistent option in exp command.

544

---

---

How can I introduce multiple conditions in like operator?

545

---

How to drop an existing view in oracle?

560

---

what is meant by magic query

1764

---

Why do we need oracle client?

504

---

What to do if the binary spfile is wrong for the default instance?

553

---

what is reindexing?

1164

---

How do I uninstall oracle 11g?

550

---

Explain the function of optimizer in oracle?

585

---

What is oracle used for?

527

---

How many data types are supported?

610

---