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 write a query with a right outer join in oracle?

830

---

Describe the types of sub query?

739

---

How to use group functions in the select clause using oracle?

794

---

How to get a list of all user accounts in the database?

824

---

Explain integrity constraint?

861

---

What is the disadvantage of User defind function?

2021

---

Difference between open_form and call_form in oracle.

864

---

List out the difference between commit, rollback, and savepoint?

796

---

What are the varoius components of physical database structure of oracle database?

743

---

How do I uninstall oracle 11g?

778

---

Can a parameter be passed to a cursor?

796

---

How to use values from other tables in update statements using oracle?

820

---

Explain constraining triggers.

825

---

How to store only time; not date and time?

723

---

What are nested tables?

843

---