What are the blocks in stored procedure?

6 Answers   Microsoft,

---

What is assignment operator in pl sql?

0 Answers  

---

Explain the difference between triggers and constraints?

0 Answers  

---

what is meant by databases

4 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. pls give me answer. i want urgent

3 Answers  

---

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

0 Answers  

---

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

0 Answers  

---

What are string functions in sql?

0 Answers  

---

What is the difference between cross join and natural join?

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

How do I trace sql profiler?

0 Answers  

---

Can we write create command in the plsql block?if possible how?

2 Answers  

---