Answer Posted / punit chauhan

select * from emp_record e1 where (3-1) = (select count ( distinct (e2.salary)) from emp_record e2 where e2.salary > e1.salary

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1893

---

Explain the use of rows option in exp command.

1147

---

What is the difference between substr & instr functions?

1292

---

What is program global area (pga) in oracle?

1090

---

What is a user account in oracle?

1168

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5476

---

How to lock and unlock a user account in oracle?

1160

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2545

---

What is a data dictionary and how can it be created?

1236

---

How to list all user accounts in oracle?

1065

---

Explain implicit cursor.

1075

---

What is oracle open database communication (odbc)?

1082

---

What is the relation of a user account and a schema in oracle?

1126

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2310

---