Answer Posted / vsubbaiah

Implicit : Every SQL Statement performed as implicit cursor. Ex: Select * from Emp where empno = 7839 This is query automatically open the cursor and fetch the record getting the output of that record.

Explicit : In PLSql Block in we declare on declaration section we declare with name and select statement. In executable block we call the cursor and fetch the records more the one. For Ex : Declare
cursor c1 is select * from emp
getemp c1%rowtype;
begin
open c1;
loop
fetch c1 into getemp;
dbms_output.put_line (c1.col list);
end loop;
close c1;
end; This is explicit cursor

How to use "while" statements in oracle?

1374

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2406

---

Explain oracle insert into command?

1152

---

What happens to the data files if a tablespace is dropped?

1105

---

How a database is related to tablespaces?

1081

---

Write a trigger example in oracle?

1109

---

What is columnar storage what is the advantage?

1119

---

Can we save images in a database and if yes, how?

1108

---

How can I combine multiple rows into a comma-delimited list in oracle?

1112

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1124

---

Explain the use of inctype option in exp command.

1079

---

How to open and close an explicit cursor in oracle?

1093

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2309

---

How to pass a cursor variable to a procedure?

1151

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1120

---