adspace


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

Can delete statement be rollbacked?

1065


how to start mysql server? : Sql dba

1279


Do we need to rebuild index after truncate?

1154


what are the advantages of sql ? : Sql dba

1154


what is sql server agent? : Sql dba

1188


What is the current version of postgresql?

1188


Can we use distinct and group by together?

1146


Can we rollback truncate?

1083


how to use regular expression in pattern match conditions? : Sql dba

1125


what is schema? : Sql dba

1163


Is inner join faster than left join?

1287


Does group by remove duplicates?

1120


what is dbms? : Sql dba

1070


What is the current version of sql?

1106


Is primary key clustered index?

1028