Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors?
- 4 Answers
- 9058 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swapna
They are used to display information of a table into
effective number and also display more than one record at a
time.
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain what is the difference between olap and datawarehosue?
How to create context?
What is the use of dimensional modeling in data warehousing?
Explain what is data validation strategies for data mart validation after loading process?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Explain bus schema?
What is the use of incremental aggregation? Explain me in brief with an example?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain what are the advantages and disadvantages of reporting directly against the database?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What are the steps involved in creating dimensional modeling process?
What is scd1 , scd2 , scd3?
Teradata 
