Answer / umasankar

A cursor is a handle or name for sql area
two types of cursors they are
Explicit cursor: Created by user
Implicit Cursor: created by oracle automatically when ever
DML is performed.

Answer / swamy.l.n

1.A PRIVATE MEMORY/BUFFER.
2.IT IS USED TO HOLD THE DATA FROM TABLES OR VIEWS IN
MEMORY LOCATION FOR MANIPULATION PURPOSE.
3.VALID IN PL/SQL BLOCK ONLY.
4.ARE VARIABLE THAT YOU CAN DEFINE IN THE DECLARE SECTION
OF THE PL/SQL BLOCK.
ORACLE USES WORK AREA CALLED PRIVATE SQL AREAS TO EXECUTE
SQL STATEMENT AND STORE INFORMATION.
5.IT IS A VIRTUAL TABLE TO PROCESS MULTIPLE RECORDS IN
PL/SQL CONSTRUCT.

Answer / swapna

They are used to display information of a table into
effective number and also display more than one record at a
time.

Answer / harshad

As this would be not specific DW Concept but rather more on
RDBMS Programming concept.

Cursor is nothing but the pointer of memory addres to your
query result.

Explicit Cursor : User need to specifically declared in
your program (procedure/function)

Implicit Cursor : Any DML; it will handled by RDBMS.

Where the cache files stored?

0 Answers  

---

How to load the time dimension?

0 Answers  

---

How Materialized Views are linked with Oracle DataWare house?

1 Answers   Kirloskar,

---

Explain what are non-additive facts?

0 Answers  

---

what is the diffrence between psa and idoc

0 Answers   iGate,

---

How to get the first 100 rows from the flat file into the target?

0 Answers  

---

What is a full backup?

0 Answers  

---

What are universe requirements?

0 Answers  

---

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

0 Answers  

---

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

1 Answers  

---

What is the difference between power center & power mart?

0 Answers  

---

What is XMLA ?

1 Answers  

---