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 transaction control statement and how many types of transaction control statement in Oracle?

1077

---

What is the difference between view and materialized view in Oracle?

1090

---

What is not equal to in oracle?

948

---

Compare and contrast between sql and sql server and explain its various functions?

913

---

What is the oracle implicit cursor?

994

---

how to handle exceptions in post production

1358

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1978

---

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

1008

---

How to convert times to characters in oracle?

976

---

Explain about your project and its relation to the current job position you are applying to?

942

---

How to use subqueries with the in operator using oracle?

1029

---

Point the difference between translate and replace?

1024

---

What are the tools for Oracle ?

1002

---

What is meant by joins?

1011

---

Difference between hot backup vs. Cold backup?

941

---