Oracle XSQL- P20Welcome to the exciting world of eXtended Structured Query Language (XSQL) development! What’s so exciting? Efficiency and ease of use. XSQL isn’t some razzle-dazzle technology to wow your users. It also isn’t the latest X standard du jour that no one can stop talking about until you ask, “But what does it do for me today?” The problem with all of the great stuff out there is that no one technology does it all. | 360 Chapter 13 string The string function converts an object to a string. string string node_set_to_convert string string number_to_convert string string boolean_to_convert string string string_to_convert string string object_to_convert string string Table lists the parameters. string-length The string-length function returns the number of characters in a string. number string-length target_string number string-length If a string is passed to the function its length will be returned otherwise the string value of the context node is returned. Table string Parameters ARGUMENT DESCRIPTION node_set_to_convert The string value is returned to the first node in document order of the node set. number_to_convert A number is converted as normal with the following exceptions an infinite number which is returned as the string Infinity or -Infinity and not a number which is returned as NaN . boolean_to_convert If true the string true is returned. If false the string false is returned. string_to_convert If a string is passed it will be returned without modification. object_to_convert If some other type of object is passed its conversion will be object-dependent and not defined by XPath. XSLT In-Depth 361 Substring The substring function returns a substring of a string. string substring superstring beginningpos end_pos string substring superstring beginning_pos Table lists the arguments. The numbering of characters is different than it is in Java and ECMAScript where the position of the first character is 0. For this function the first character is at position 1 and the last character s position is equivalent to the length of the string. If you pass 0 as the second argument it will resolve as 1. If you pass a noninteger it will be rounded to an integer and the integer will be evaluated. The function will return the empty string if the arguments don t make sense because the third argument is less than the second argument an argument is negative an argument is .