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 is the data type of the surrogate key?
What is dimensional modelling?
What is factless fact tables?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is the function of surrogate key in data warehousing?
Explain vldb?
What is the difference between olap and oltp?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Why fact table is in a normal form?
How to create different types of templates?
Explain what is data validation strategies for data mart validation after loading process?
Explain what are conformed dimensions?
Explain the main difference between inmon and kimball philosophies of data warehousing?
Explain clustering algorithm?
What are the stages of datawarehousing?