Answer Posted / ashwini

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

Which are the different character-manipulation functions in sql?

1072

---

Give the order of sql select?

1142

---

Explain the uses of control file.

1051

---

How to download oracle sql developer?

1119

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1201

---

What is the difference between null value, zero, and blank space?

1209

---

what is the difference between primary key and unique key? : Sql dba

1042

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2577

---

Define implicit and explicit cursors.

1150

---

What do you understand by pl/sql cursors?

1093

---

explain primary keys and auto increment fields in mysql : sql dba

982

---

Can primary key be changed?

913

---

Is sql a scripting language?

1023

---

What packages are available to pl/sql developers?

1069

---

What is partition by in sql?

1074

---