Answer Posted / azuan

example

explain analyze select br_loc,count(insp_id) from insp where
date_create between '2010-07-01 00:00:00' and '2010-07-31
23:59:59' group by br_loc

What is a recursive join sql?

597

---

What is a schema? How is it useful in sql servers?

596

---

what are the different tables present in mysql? : Sql dba

506

---

what is a constraint? : Sql dba

715

---

List different type of expressions with the example.

551

---

---

Does pl sql work in mysql?

538

---

What is cartesian join in sql?

559

---

What is restrict in sql?

561

---

What are the differences between implicit and explicit cursors?

524

---

What is faster join or subquery?

514

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

556

---

Why self join is used in sql?

499

---

Why do we use function in pl sql?

562

---

What are the two types of periodical indexes?

510

---

Advantages and disadvantages of stored procedure?

583

---