Answer Posted / shiva kumar

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

in mainframe env

What view means?

975

---

What problem one might face while writing log information to a data-base table in pl/sql?

1157

---

What is a ddl command?

1083

---

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

1196

---

what is error ora-03113: end-of-file on communication channel?

1159

---

What is %rowtype in pl sql?

987

---

What is a pdo connection?

1030

---

What is the difference between pl and sql?

1091

---

Is sql developer case sensitive?

994

---

What does partition by mean in sql?

959

---

Does pl/sql support create command?

1102

---

Sql technical questions

1273

---

What is tuple in sql?

1070

---

What is a function in oracle pl sql?

1035

---

what are date and time data types in mysql? : Sql dba

968

---