What are cursors? Explain different types of cursors?
- 6 Answers
- 27347 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramesh
Implicit Cursors --Occurs on behalf of every sql statement
Explicit Cursors --Named Cursors used in Plsql
Paramaeteried Cursors --Pass Paramters to a Named Cursor
Cheers,
Ramesh
| Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
How long can an error message be in raiseerror function?
In which table collections errors are stored.
How can you log an error to the server event log from a stored procedure?
In which database can extended stored procedures be added?
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).
Why does this query return 0?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain about relational database management systems?
Explain about network 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?
Explain about xml databases?
What is an application role and explain a scenario when you would use one?
Explain the rollup operator?
Explain about the relational database?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
