What are cursors? Explain different types of cursors?
Answer Posted / daudkhan
A point to context area which has infromation for Oracle to
process SQL statements.
Cursors allow to fetch rows returned by a select statement.
Implicit cursor: Automatically declared
Explicit cursor: defined by programmer
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
Write short notes on manual refreshes.
Which four data types cannot be used as a return type from a user-defined function?
What are data modelling techniques?
How to customize error conditions.
What is an application role and explain a scenario when you would use one?
fact table and dimension table containg one to many relationship or many to one relastionship
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
What is normalization? Explain different levels of normalization?
How long can an error message be in raiseerror function?
How you can make a parameterized view?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain about post-relational databases?
How is data stored in dbms?
Explain about relational operator join?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?