Oracle XSQL- P13Welcome 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. | 220 Chapter 8 Table Simple Conversion Functions FUNCTION DESCRIPTION Asciistr Returns the ASCII string. Non-ASCII characters are converted to their Unicode UTF-16 binary code value. Chartorowid Changes a string to a row id. Compose Returns a fully normalized Unicode string. Hextoraw Converts a hexadecimal number to a raw value. Rawtohex Converts a raw value to a hexadecimal number. Rowidtochar Converts a row id to a string. To_char Converts argument to a string. To_clob Converts argument to a clob. To_date Converts argument to a date. To_dsinterval Converts argument to a day-second interval. To_lob Converts argument to a lob. To_multi_byte Converts a single character to a multibyte character. To_nchar Identical to to_char except that it converts to the national character set. To_nclob Converts to the national character set. To_number Converts string to number. Generally not used because Oracle automatically performs the conversion. To_singlebyte Converts a multibyte character to single byte if possible. To yminterval Converts argument to a year-month interval. When used with dates the to_char function takes the same format as that described in the Date Formatting section. When the to_char function is passed a number it must decide how to appropriately output the string. It does this by using a format mask similar to the date format mask you learned about earlier. The most important element is the number 9. It represents a significant digit and the number of 9 s represents the number of significant digits that you want displayed. Table lists the number-format elements. Oracle SQL 221 Table Number-Format Elements ELEMENT DESCRIPTION A significant digit A padding zero. Usually appears on the left. Places a dollar sign in the output. Places a comma in the output. . Places a period in the output. B Zero values are displayed as blanks. MI Negative sign for negative values. S Forces the sign of the number to be displayed. PR Places negative values to be