PHP MySql Web Hosting

,ch04.13730 Page 189 Wednesday, November 29, 2000 4:43 PM Table 4-9: Oracle-Supported Functions (continued) Function replace(string, search_ string [,replacement_ string]) round (number, decimal) round (date[, format]) row_number ( ) over ( query_partition ORDER BY ) rowidtochar(rowid) rpad(string1, number [, string2]) rtrim(string[,set]) sign(number) sin(number) sinh(number) soundex(string) sqrt(number) stddev( [DISTINCT] expression) over (analytics) stdev_pop(expression) over (analytics) seddev_samp(expression) over (analytics) substr(extraction_string [FROM starting_position] [FOR length]) substrb(extraction_string [FROM starting_position] [FOR length]) sum([DISTINCT] expression) over (analytics) sys_context ( namespace , attribute [,length]) sys_guid( ) sysdate tan(number) Description Returns string with every occurrence of search_string replaced with replacement_string. Returns number rounded to decimal places right of the decimal point. When decimal is omitted, number is rounded to 0 places. Note that decimal, an integer, can be negative to round off digits left of the decimal point. Returns the date rounded to the unit specified by the format model format. When format is omitted, date is rounded to the nearest day. Assigns a unique number to each row where it is applied in the ordered sequence of rows specified by the ORDER_BY_ clause, beginning with 1. Converts a rowid value to VARCHAR2 datatype, 18 characters long. Returns string1, right-padded to length number with the value of string2, repeated as needed. String2 defaults to a single blank. Returns string, with all the rightmost characters that appear in set removed; set defaults to a single blank. When number < 0, returns 1. When number = 0, returns 0. When number > 0, returns 1. Returns the sine of number as an angle expressed in radians. Returns the hyperbolic sine of number. Returns a character string containing the phonetic representation of string. This function allows words that are spelled differently but sound alike in English to be compared for equality. Returns square root of number, a nonnegative number. Returns sample standard deviation of a set of numbers shown as expression. Computes the population standard deviation and returns the square root of the population variance. Computes the cumulative sample standard deviation and returns the square root of the sample variance. Refer to the earlier section on SUBSTR. SUBSTRB is the same as SUBSTR, except that the arguments m starting_position and length are expressed in bytes, rather than in characters. Returns sum of values of expr; refer to vendor documentation for assistance with analytics and the OVER subclause. Returns the value of attribute associated with the context namespace, usable in both SQL and PL/SQL statements. Generates and returns a globally unique identifier (RAW value) made up of 16 bytes. Returns the current date and time, requiring no arguments. Returns the tangent of number as an angle expressed in radians. Functions Vendor Extensions 189

Note: If you are looking for good and high quality web space to host and run your application check Lunarwebhost PHP MySQL Web Hosting services