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 a query and a report?

0 Answers  

---

Can we join tables without foreign key?

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

Can we alter stored procedure?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

How do I remove sql developer from windows 10?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

What is the difference between a primary key and a unique key?

0 Answers  

---

What is data manipulation language?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---