oracle 存储过程函数汇总（Oracle存储过程函数汇总）.docVIP

oracle 存储过程函数汇总（Oracle存储过程函数汇总） Character function - returns the character value All of these functions receive parameters of the character family type (except CHR) and return the character value In addition to special instructions, most of these functions return values of type VARCHAR2 The restrictions on the return type of the character function are the same as those for the base database type. The maximum value stored by character type variables: The VARCHAR2 value is limited to 2000 characters (4000 characters in ORACLE 8) The CHAR value is limited to 255 characters (2000 in ORACLE8) Long type is 2GB Clob type is 4GB 1, CHR Syntax: Chr (x) Function: returns characters that have equivalent values to X in the database character set. CHR and ASCII are a pair of inverse functions. After the conversion of CHR characters, and then through the ASCII conversion, and get the original word Fu. Using location: procedural statements and SQL statements. 2, CONCAT Syntax: CONCAT (string1, string2) Function: returns string1, and connects string2 at the back. Using location: procedural statements and SQL statements. 3, INITCAP Syntax: INITCAP (string) Function: returns the first letter of each word in the string, uppercase, and the other letter in the word, lowercase string. Words are separated by spaces or letters and numbers. Not letter Characters are not changed. Using location: procedural statements and SQL statements. 4, LTRIM Syntax: LTRIM (string1, string2) Function: returns the string1 of the characters that appear in the string2 from the left. String2 is set to a single space by default. The database will scan string1, starting at the far left. When When the first character is not in the string2, the result is returned. LTRIMs behavior is similar to that of RTRIM. Using location: procedural statements and SQL statements. 5, NLS_INITCAP Syntax: NLS_INITCAP (string[, nlsparams]) Function: returns the string, the first letter of each word, uppercase, and the other letter