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;

how many columns can be used for creating index? : Sql dba

946

---

Is sql an operating system?

1018

---

Why do we need sharding?

988

---

How insert into statements in sql?

1072

---

How do I count duplicates in sql?

1105

---

What are the types of subqueries?

1055

---

Explain the difference in execution of triggers and stored procedures?

1022

---

Explain select statements in sql?

1056

---

what is a cursor? : Sql dba

1022

---

How many types of indexes are there in sql?

983

---

what is 'mysqldump'? : Sql dba

1108

---

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

1082

---

What is a schema sql?

1152

---

What are the ways on commenting in a pl/sql code?

1133

---

what is a control file ? : Sql dba

1037

---