Answer Posted / 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 |
Post New Answer View All Answers
Explain the difference between dw and bi?
Explain what is the metadata extension?
I have two universes created by two difference database can we join them in designer & report level? How
What is crass reference table?
What are the possible data marts in retail sales?
What are target types on the server?
What is real-time datawarehousing?
Explain bus schema?
What is the difference between Datawarehouse and OLAP?
Explain the different types of data warehousing?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is the 4 + 1 view model as it relates to system modeling?
How to load the time dimension?
Explain what are the various transformation available?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?