What are cursors? Explain different types of cursors?
Answer Posted / banoj swain
cursor is nothing but a pointer pointing to the context area assigned by oracle for processing of sql statement.pl/sql programs control context area by using cursor.
types:1)static 2)dynamic or ref cursor
again static is of two types
1)explicit 2)implicit
dynamic of two types:
1)strong 2)weak
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
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?
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 are the 18 schemas?
Who are end users in dbms?
Explain about the database management systems.
How can you fix a poorly performing query?
In which database can extended stored procedures be added?
In which table collections errors are stored.
What is the physical representation for a many-to-many relationship?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How is data stored in 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?
State the acid rules?
What is an application role and explain a scenario when you would use one?
Explain about relational database management systems?