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 load data from external tables to regular tables?

1062

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2066

---

How to rename an index in oracle?

1118

---

Can we write insert statement in function in oracle?

1095

---

How to load data through external tables?

1140

---

What is clustered table in Oracle?

1199

---

Why does oracle 9i treat an empty string as null?

1060

---

How to assign data of the deleted row to variables?

1076

---

What is a data lock in oracle?

1127

---

How to convert characters to dates in oracle?

1103

---

What is a nvl function? How can it be used?

1035

---

What is an index associated with a constraint?

1040

---

Where do we use decode and case statements?

1017

---

Does oracle partitioning improve performance?

1001

---

What is difference between truncate and delete?

1043

---