Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Explain different types of cursors?
- 6 Answers
- 28515 Views
- I also Faced
- E-Mail Answers
Answer Posted / preethi
Cursors are work areas used for internal processing in
order toexecute an SQL statement.
Two tpes of Cursors
Implicit Cursors and Explicit Cursors.
Explicit Cursors can be further classifed into three
Named Cursors,Parameterized Cursors and Ref Cursors
| Is This Answer Correct ? | 28 Yes | 8 No |
Post New Answer View All Answers
fact table and dimension table containg one to many relationship or many to one relastionship
Can an extended stored procedure be called from inside a user-defined function?
What is normalization? Explain different levels of normalization?
State the acid rules?
Explain the process of the user request and data generating?
Who are naive users?
What are the types of database model?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Which data type cannot be used as a parameter in a udf?
Explain about the storage and physical database design?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
How to replace not in with not exist?
What is an application role and explain a scenario when you would use one?
Explain about post-relational databases?
What are the three types of database design?
