(1)Query():-It is use to extract XML fragments from an XML data type.
(2)Value():-It is used to extract a single value from an XML fragment.
(3)Exist():-It is generally used to determine whether a xml record exist or not. Return 1 if exist else return 0.
(4)Modify():-It is used to updates XML data in an XML data type.
(5)Nodes():-It is used to shred XML into multiple rows to propagate parts of XML documents into rowsets.