Answer Posted / sachin

select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);

Is crud a cuss word?

988

---

how to use case expression? : Sql dba

980

---

Can there be more than one function with a similar name in a pl/sql block?

949

---

How do I order by ascending in sql?

979

---

How to combine two stored procedures in sql?

1155

---

What is the difference between the conventional and direct path loader? : aql loader

1132

---

Do prepared statements prevent sql injection?

918

---

In pl/sql, what is bulk binding, and when/how would it help performance?

966

---

What is the difference between partitioning and sharding?

974

---

how do you control the max size of a heap table? : Sql dba

950

---

What is pls_integer in pl sql?

1052

---

How many joins can you have in sql?

898

---

What is the use of sql trace?

923

---

Why we use triggers in mysql?

963

---

Can you load data into multiple tables at once? : aql loader

1043

---