Answer Posted / suneel

select level,max(sal)from af where level=3 connect by prior
sal>sal group by level;

Which is better stored procedure or query?

548

---

how to convert dates to character strings? : Sql dba

539

---

What are the 3 modes of parameter?

681

---

What does sign mean sql?

573

---

Can two tables have same primary key?

531

---

---

What is the difference between a subquery and a join?

529

---

What are the various restrictions imposed on view in terms of dml?

523

---

Can triggers stop a dml statement from executing on a table?

618

---

Describe types of sql statements?

548

---

how many triggers are allowed in mysql table? : Sql dba

559

---

What is online transaction processing (oltp)?

605

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

635

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

573

---

Show code of a cursor for loop.

584

---

What is row_number () in sql?

548

---