Ultimos Posts 1. 19/12/2008 21:36 - Oracle - string functions : rtrim the rtrim function removes all specified characters from the right-hand side of a string. The syntax is: rtrim( string1, [ trim_string ] ) string1 is the string to trim the characters from the right-hand side. trim_string is the string that will be removed from the right-hand side of string1. If this parameter is omitted, the rtrim function will remove all trailing spaces from stri... 2. 19/12/2008 21:28 - Oracle - string functions : length The length function returns the length of the specified string. The syntax is: length( string ) string is the string to return the length for. If string1 is NULL, then the function returns NULL. For example: length('Hola Mundo') would return 10. length('') would return NULL.... 3. 22/09/2008 21:59 - Oracle - conversion functions : to_char the to_char function converts a number or date to a string. The syntax : to_char( value, [ format_mask ], [ nls_language ] ) value can either be a number or date that will be converted to a string. format_mask is optional. This is the format that will be used to convert value to a string. nls_language is optional. This is the nls language used to convert value to a string. Examples... 4. 22/09/2008 21:59 - Oracle - string functions : instr The instr function returns the location of a substring in a string. The syntax is: instr( stringA, stringB [, start_position [, nth_appearance ] ] ) stringA is the string to search. stringB is the substring to search for in stringA . start_position is the position in stringA where the search will start. This argument is optional. If omitted, it defaults to 1. The first position in ... 5. 22/09/2008 21:30 - Oracle - conversion functions : to_number The to_number function converts a string to a number. The syntax is: to_number( string1, [ format_mask ], [ nls_language ] ) string1 is the string that will be converted to a number. format_mask is optional. This is the format that will be used to convert string1 to a number. nls_language is optional. This is the nls language used to convert string1 to a number. For example: to_num... | Estadisticas Ver Codigo HTML Posicion del Blog en Nuestro Ranking Hits Semanales Hits Mensuales |