What are cursors? Explain different types of cursors?
Answer Posted / siva
cursor is nothing but buffer area it is process by multiple records and also record by record process.
they are two types
1.implicit cursor:- it is returned only single value.(it is created by default system )
2.explicit cursor:- it is returned multiple values.( it is created by user).
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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 the hierarchical model of the database?
What is an application role and explain a scenario when you would use one?
Explain about query and reporting.
In which table collections errors are stored.
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
Which data type cannot be used as a parameter in a udf?
explain detail about ftp in datastage?
What is the database development process?
Explain the rollup operator?
How to replace not in with not exist?
Explain the process of the user request and data generating?
How to combine two function together?
What are the 18 schemas?