Home > IT Answers > Oracle > Value of() in SQL Server?
Prcvjr
220 pts.
 Value of() in SQL Server?
Oracle Statements, SQL, SQL Server, SQL Server 2005
what is the equivalent statement of valueof() of oracle in sql server?

Software/Hardware used:
Sql Server 2005
ASKED: December 16, 2010  12:22 PM
UPDATED: December 16, 2010  10:04 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Are you referring to the DBMS_XSLPROCESSOR Oracle’s package ?

If so, I think you should explain what you need to achieve without assuming that the SQL Server experts who know how to process XML documents in SQL Server also know how to do it in Oracle and know the ValueOf procedure/function.

carlosdl
 63,580 pts.
 

What does this function do? Is it a native function? I couldn’t find anything called valueof() via Google.

Denny Cherry
 64,550 pts.
 

Hi Denny.

There is an Oracle Package named DBMS_XSLPROCESSOR, which “provides an interface to manage the contents and structure of XML documents”.

The VALUEOF Function and Procedure “retrieves the value of the first node from the tree that matches the given pattern”.

There is no other ValueOf function or procedure in Oracle, but I’m not sure if that is what the OP meant. It could be a totally different thing. In Java, for example, it is a type conversion method.

carlosdl
 63,580 pts.