Answer Posted / pramod janjirala

select max(sal),ename from emp where sal=(select max(sal)
from emp) group by ename;

What are the different dml commands in sql?

584

---

what is cross join? : Sql dba

568

---

Can a commit statement be executed as part of a trigger?

598

---

What is schema in sql example?

595

---

What is the purpose of using pl/sql?

661

---

---

What is not in sql?

495

---

What is the example of procedure?

517

---

What is sqlcontext?

549

---

what is heap table? : Sql dba

604

---

What is normalisation in sql?

548

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1643

---

What is use of term?

616

---

How do I order columns in sql?

525

---

What is denormalization in a database?

587

---

How to use sql*plus built-in timers?

576

---