Answer Posted / karthikeyan

select max(sal) from emp
where sal <(select max (sal)from emp);

What is a dead lock in oracle?

1176

---

How to drop an existing view in oracle?

992

---

What do you understand by database schema and what does it hold?

1299

---

What are the different pseudo commands? Explain in general?

1124

---

How to find the duplicate rows count from employees table in oracle?

1146

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

---

What is merge in oracle?

1096

---

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

2395

---

How to delete a column in an existing table in oracle?

1127

---

When do I need to use a semicolon vs a slash in oracle sql?

1142

---

What is a sub query? Describe its types?

1072

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1993

---

How to view all columns in an existing table?

981

---

Explain the difference between replace() and translate() functions in oracle?

1086

---