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
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Is union transormation is active transformation?
What is index awareness in universe?
in general which algorithms for used?
Explain what is a view as it relates to system modeling?
Explain what is the data type of the surrogate key?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain a relation schema and a relation?
Store (and count) non-fact records?
Suppose we want to display zero when null values coming to report how can we do that?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What are the approaches used by optimizer during execution plan?
Explain vldb?
Explain what are the advantages data mining over traditional approaches?
How many types of facts and what are they?