how a reference cursor works?what all adnvantages are
gained with it..specify the situation?

Answer Posted / a.jyothsna

Difference between cursor and ref-cursors is same as the
difference between variable and constant.
With ref-cursors we can use the cursors variable.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does asenumerable execute the query?

595


how to escape special characters in sql statements? : Sql dba

509


What is a trigger in sql?

634


What do you mean by dbms? What are its different types?

552


When sql appeared?

618






Does varchar need length?

516


how to enter numeric values as hex numbers? : Sql dba

565


Which tcp/ip port does sql server run?

531


How can you load microsoft excel data into oracle? : aql loader

613


What is crud sql?

538


Which is better trigger or stored procedure?

499


What are the ddl commands?

533


What is oracle pl sql developer?

530


Why do we use procedures?

513


What are the different types of dbmss?

561