Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between value and deref clause in oop

575729Mar 2 2008 — edited Mar 5 2008
hi

what is difference between value clause and deref clause in object orient programming in plsql. i try to understand it from documentation but did succeed. here is my confusions

so times in oracle documentation i see an example like this

select value(i) into object_variable
from table i;

why value is used here if for getting value of the object then sometimes i see an example like this

selet i into object_variable
from table i

where i is an object. what am i missing here. please help
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2008
Added on Mar 2 2008
7 comments
3,383 views