What are cursors? Explain different types of cursors?
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
I have a few records all are same structures data, I want to store data in multiple targets how
What is a database development?
Write the fastest query to find out how many rows exist in a table?
What are the key features of dbms?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Explain what a database is?
Explain about post-relational databases?
What is dbms explain in brief?
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?
What is data modeling with example?
fact table and dimension table containg one to many relationship or many to one relastionship
How to combine two function together?
What are the three types of database design?
How is data stored in dbms?
In which database can extended stored procedures be added?