What are cursors? Explain different types of cursors?
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
explain detail about ftp in datastage?
How long can an error message be in raiseerror function?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is dbms and its application?
What are data modelling techniques?
Who are naive users?
How can you log an error to the server event log from a stored procedure?
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?
Why does this query return 0?
Explain about relational database management systems?
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 relational database?
In which table collections errors are stored.
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
What is an application role and explain a scenario when you would use one?