How can you create Cursor with parametres ?

3 Answers  

---

What is the usage of sql functions?

0 Answers  

---

can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?

2 Answers   Fujitsu,

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

---

How can I see all tables in sql?

0 Answers  

---

how can you see all indexes defined for a table? : Sql dba

0 Answers  

---

What is the use of function in sql?

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

3 Answers  

---

what is global variable in pl/sql

1 Answers  

---

what are different types of keys in sql?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---