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

What is blob datatype?

1128

---

Explain oracle insert into command?

1110

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1045

---

How to use null as conditions in oracle?

1083

---

What are the various oracle database objects?

1144

---

How to get the Installed Oracle Version Information ?

1123

---

What are the differences between blob and clob in oracle?

1089

---

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

1078

---

Why use resource manager in Oracle?

1104

---

How to invoke the data pump import utility?

1162

---

Is the After report trigger fired if the report execution fails ?

2915

---

How do I uninstall oracle 11g?

1117

---

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

---

candidate key is subset of super key but not vice-verse explain

2068

---

What is the quickest way to fetch the data from a table?

1058

---