PLSQL函数一览(国外英语资料).doc

PLSQL函数一览(国外英语资料) Topic: PL/SQL single line function and group function list (rotation) Author: Jiezhi (western regions prodigal son) ***************** Single string function: ***************** Single string functions are used to manipulate string data, most of them have one or more parameters, most of which return strings ------------------------------------------------------------------------------ ASCII () C1 is a string that returns the ASCII code of the first letter of the C1, and his inverse function is CHR () SELECT, ASCII (A), BIG_A, ASCII (z), BIG_z, FROM, EMP BIG_A BIG_z 65122 ------------------------------------------------------------------------------ CHR ( I ) [NCHAR_CS] I is a numeric, function that returns the decimal representation of the characters Select, CHR (65), CHR (122), CHR (223), FROM, EMP CHR65 CHR122 CHR223 A Z B ------------------------------------------------------------------------------ CONCAT (()) C1, C2 are string, function to connect C2 to the back of C1, if C1 is null, will return c2., if C2 is null, then return C1, if C1 and C2 are all null, then return null. He and || operators return the same result Select concat (slobo ,Svoboda) username from dual Username Slobo Syoboda ------------------------------------------------------------------------------ INITCAP () C1 is a string. The function will capitalize the first letter of each word and return the other letter in small case. The word is limited by spaces, control characters, and punctuation. Select, INITCAP (veni, Vedi, vici), Ceasar, from, dual Ceasar Veni, Vedi, Vici ------------------------------------------------------------------------------ (INSTR, [[, I , edit) C1, C2 are strings, I, J are integers. The function returns the position where C2 appears in C1 at J, and searches from the first I character of c1. When no character is found, 0 is returned. If I is negative, then the search proceeds from right to left, but the location is computed from left to right, and the de