首页 > 数据库 > Oracle > OracleCharacter
OracleCharacter
Datatype Definition
VARCHAR2(size) Variable-length character string having a maximum of size bytes (up to 4000).
CHAR(size) Fixed-length character data, size characters long. Maximum size is 2000.
Default is 1 byte. Padded on the right with blanks to full length of size.
Function Definition
LENGTH(string) This tells the LENGTH of a string.
CHR(integer) CHR gives the character with an ASCII value equal to a given positive integer.
INSTR(string, set [, start [ ,occurrence ] ] )
INSTR finds the location of the beginning of a set of characters IN a STRing.
SUBSTR(string, start [,count])
SUBSTRing clips out a piece of a string beginning at start position and counting for count
characters from start.
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10484922/viewspace-1023062/,如需转载,请注明出处,否则将追究法律责任。