Value Function
What is the use of value function ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Anuja PawarPosted Dec 8, 2011, 9:49 AM
Arjun PanwarPosted Dec 8, 2011, 7:02 AM
Thanks for reply ... good explaination
Anuja PawarPosted Dec 6, 2011, 2:38 AM
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_scalarfunctionsintro.htm
and one more
Value() treats the row as an actual object and returns the attributes for the object within a constructor for the object type.
The VALUE() function accepts a parameter containing a table alias
http://www.java2s.com/Tutorial/Oracle/0620__Object-Oriented/UsethebuiltinOracledatabaseVALUEfunctiontoselectarowfromanobjecttable.htm
Satyapriya NayakPosted Dec 6, 2011, 2:19 AM
The VALUE function returns the first argument that is not null. VALUE is a synonym for the COALESCE function.
Refer
http://www.java2s.com/Code/Oracle/Object-Oriented-Database/VALUEfunctionforobject.htm
Thanks