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

Explain oracle insert into command?

1101

---

What is Library Cache in Oracle?

1129

---

What is the difference between alert log file and tarce file ?

2161

---

What is concurrency in oracle?

998

---

Explain about achiever in sql?

1020

---

How to connect ms access to oracle servers?

994

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1933

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1924

---

How to start your 10g xe server from command line?

1067

---

What is the relationship among database, tablespace and data file?

977

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1127

---

Differentiate between pre-select and pre-query?

1098

---

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

1077

---

How to count groups returned with the group by clause in oracle?

1061

---

How to view the data files in the current database?

1091

---