Answer Posted / souri sengupta

select max(salary) from employee where salary not in (select max(salary) from employee);


This worked :)

What types of joins are used in writing subqueries?

1032

---

IS it possible to built the oracle database without setting the kernal parameters?

2397

---

How to convert numbers to characters in oracle?

1079

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1474

---

Explain compound trigger in oracle?

1091

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2248

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

---

Explain user account with reference to oracle.

1031

---

What happens to the current transaction if the session is killed?

1039

---

How many categories of data types in oracle?

1075

---

List out the types of joins.

1240

---

How to invoke the original export import utilities?

1135

---

What is a server parameter file in oracle?

1098

---

What are the execution control statements in oracle?

1133

---

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

2798

---