What is materialized view in sql?

0 Answers  

---

What are the sql aggregate functions?

0 Answers  

---

How is indexing done in search engines?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

Is a view faster than a stored procedure?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

How is debugging done?

0 Answers  

---

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

---

Is sql workbench free?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---