Answer Posted / 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;

Is primary key a clustered index?

1008

---

What are the types of join in sql?

1146

---

What is the need of merge statement?

1092

---

What are types of joins?

1026

---

Is keyword pl sql?

1055

---

Why sql query is slow?

1040

---

What is percent sign in sql?

1324

---

What is cursor explain with example?

1027

---

How many types of cursors are available in pl/sql?

1158

---

Why is theta join required?

1188

---

What does closing a cursor do?

1372

---

Is full outer join same as cross join?

1013

---

What are sql commands?

1066

---

what does it mean to have quoted_identifier on? : Sql dba

1180

---

What is the difference between left and left outer join?

991

---