Difference between cursor and ref-cursors is same as the difference betwe

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

Question Posted / a.jyothsna

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

Please Help Members By Posting Answers For Below Questions

What's the difference between inner join and left join?

999

What is pls_integer in pl sql?

1105

How can a function retun more than one value in oracle with proper example?

1074

Is sql a backend?

1020

What are character functions in sql?

938

Is a table valued function object?

1015

What is break?

1197

Explain the difference in execution of triggers and stored procedures?

1022

How to set up sql*plus output format in oracle?

1037

How would you pass hints to the sql processor?

980

What is the maximum number of triggers, you can apply on a single table?

998

What is trigger in sql?

1097

What are the dml statements?

1141

How many tables can a sql database have?

977

Is nosql relational?

943