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
What are data modeling and data mining? Where it will be used?
What is loop in data warehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are steps we have to follow in designing the userfriendly universe?
Explain dimension table ?
Explain what are the various reporting tools in the market?
What are the different models used in cluster analysis?
What is the very basic difference between data warehouse and operational databases?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
I know of using applysimple, but there are other ways too?
What are the different types of data warehouses?
How to pivot data using informatica when you have variable amount of pivot rows?
Is there any difference in testing database and data ware housing?
What needs to be done when the database is shutdown?
What is mean by aggregate aware?