PHP MySql Web Hosting

,ch04.13730 Page 187 Wednesday, November 29, 2000 4:43 PM Table 4-9: Oracle-Supported Functions (continued) Function log(base_number, number) lower(string) lpad(string1, number [,string2]) ltrim(string[, set]) make_ref({table_name | view_name} , key [, n]) max([DISTINCT] expression) over (analytics) min([DISTINCT] expression) over (analytics) mod(dividend, divider) months_between (date1, date2) new_time(date, time_ zone1, time_zone2) next_day(date, string) nls_charset_decl_ len(bytecnt, csid) nls_charset_id(text) nls_charset_ name(number) nls_initcap(string [, nlsparameter ]) nls_lower(string, [, nlsparameter ]) nlssort(string [, nlsparameter ]) nls_upper string [, nlsparameter ]) Description Returns the logarithm of any base_number of number. Returns string in the same datatype as it was supplied with all characters lowercase. Returns string1, left-padded to length number using characters in string2; string2 defaults to a single blank. Removes all characters in set from the left of string. Set defaults to a single blank. Creates a reference (REF ) to a row of an object view or a row in an object table whose object identifier is primary key-based. Returns maximum value of expression. It can be used as an aggregate or analytic function (analytic functions are beyond the scope of this text). Returns minimum value of expression. It can be used as an aggregate or analytic function (analytic functions are beyond the scope of this text). Returns remainder of dividend divided by divider; returns the dividend if divider is 0. Returns number of months between dates date1 and date2. When date1 is later than date2, the result is positive. If it is earlier, the result is negative. Returns the date and time in time_zone2 when date and time in time_zone1 are date. Time_zones 1 and 2 may be any of these text strings: AST, ADT: Atlantic Standard or Daylight Time BST, BDT: Bering Standard or Daylight Time CST, CDT: Central Standard or Daylight Time EST, EDT: Eastern Standard or Daylight Time GMT: Greenwich Mean Time HST, HDT: Alaska-Hawaii Standard Time or Daylight Time MST, MDT: Mountain Standard or Daylight Time NST: Newfoundland Standard Time PST, PDT: Pacific Standard or Daylight Time YST, YDT: Yukon Standard or Daylight Time Returns the date of the first weekday named by string that is later than date. The argument string must be either the full name or the abbreviation of a day of the week in the date language of the session. Returns the declaration width (bytecnt)ofan NCHAR column using the character set ID (csid ) of the column. Returns the NLS character set ID number corresponding to text. Returns the VARCHAR2 name for the NLS character set corresponding to the ID number. Returns string with the first letter of each word in uppercase and all other letters in lowercase. The nlsparameter offers special linguistic sorting features. Returns string with all letters lowercase. The nlsparameter offers special linguistic sorting features. Returns the string of bytes used to sort string. The nlsparameter offers special linguistic sorting features. Returns string with all letters uppercase. The nlsparameter offers special linguistic sorting features. Functions Vendor Extensions 187

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