Answer / swapna

We have to use stored procedure and parameterized cursor.

Answer / vikram jayaprakash

Ref Cursor will come in handy when tables are passed
dynamically.

Answer / madhav

By using ref cursor along with reocord data type(with out
using record type we can't pass the table name dynamically)

cursor refcursor is ref cursor;---weak ref cursor
v_refcursor refcursor----cursor variable
type recordtye is record(table_record table%rowtye,.....)

begin
if not v_recordtype%isopen then
open v_recordtype for select * from emp
end if;

What is the difference between function, procedure and package in pl/sql?

0 Answers  

---

How do you write an index?

0 Answers  

---

How is debugging done?

0 Answers  

---

What does the acronym acid stand for in database management?

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  

---

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

How to call shell script from pl sql procedure?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

Is left join and outer join same?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

What is rename command in sql?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---