Answer Posted / swapnareddy

Basically, Reference cursor is datatype.Reference cursor works
as a cursor variable.the advantage of using reference cursor
is it pass the result sets to the subprograms
(ie,procedures,packages and functions etc).
example for reference cursor usage:
type r_cursor is ref cursor;
c_emp r_cursor;
ename1 emp.ename%type;
begin
open c_emp is select ename from emp;
loop
fetch c_emp into ename1;
exit when c_emp% notfound;
dbms_output.put_line(ename1);
end loop;
close c_emp;
end;

Is record in oracle pl sql?

963

---

Is like operator in sql case sensitive?

1025

---

How many rows can sqlite handle?

1112

---

Is left join inner or outer by default?

1019

---

What is the use of index in sql?

1017

---

what is a composite primary key ? : Sql dba

1050

---

What is information schema in sql?

1070

---

What is a left inner join?

1015

---

What is a temporal table?

930

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1089

---

What are different types of statements supported by sql?

1165

---

What has stored procedures in sql?

1066

---

What is lookup table in sql?

1048

---

Define select, insert, create, delete, update, drop keywords

1048

---

what is the difference between join and union? : Sql dba

1113

---