Oracle SQL 内置函数大全(国外英语资料).doc

Oracle SQL 内置函数大全(国外英语资料) Single record function in SQL 1.ASCII Returns the decimal number corresponding to the specified character; SQL, select, ASCII (A), A, ASCII (a), a, ASCII (0), zero, ASCII (` ), space, from, dual; A A ZERO SPACE ------------------------------------2.CHR Give an integer and return the corresponding character; SQL, select, Chr (54740) Zhao, Chr (65), chr65, from, dual; ZH C - Zhao A 3.CONCAT Connecting two strings; SQL select concat (010- ||23 high Qianjing telephone from dual; High Qianjing phone ---- 010turn 23 4.INITCAP Returns the string and converts the first letter of the string to uppercase; SQL, select, initcap (smith), UPP, from, dual; UPP - Smith 5.INSTR (C1, C2, I, J) Searches for a specified character in a string and returns the location of the specified character; C1 search string C2 wants to search for Strings The initial location of the I search defaults to 1 The location of the J appears to be 1 by default SQL, select, instr (oracle, traning,ra, 1,2), instring, from, dual; INSTRING - Nine 6.LENGTH Returns the length of the string; SQL, select, name, length (name), addr, length (addr), Sal, length (to_char (SAL)), from,.Nchar_tst; NAME, LENGTH (NAME), ADDR, LENGTH (ADDR), SAL, LENGTH (TO_CHAR (SAL)) --------------------------------------------------------------------------- High Qianjing 3 Beijing sea area 69999.997 ingot 7.LOWER Returns the string, and makes all characters lowercase SQL, select, lower (AaBbCcDd), AaBbCcDd, from, dual; AABBCCDD . Aabbccdd 8.UPPER Returns the string and capitalized all the characters SQL, select, upper (AaBbCcDd), upper, from, dual; UPPER . AABBCCDD 9.RPAD and LPAD (paste characters) RPAD paste characters on the right side of the column LPAD paste characters on the left side of the column SQL select lpad (rpad (gao, 10, 17, * *)) from dual; LPAD (RPAD (GAO, 1) Round and round *******gao******* Insufficient characters are filled with * 10.LTRIM and RTRIM LTRIM deletes