ITPub博客

首页 > 数据库 > Oracle > OracleCharacter

OracleCharacter

原创 Oracle 作者:YoungEric 时间:2009-06-13 11:21:01 0 删除 编辑

OracleCharacter

OracleCharacterDatatype

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.

OracleCharacterFunction

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: OracleNull
请登录后发表评论 登录
全部评论

注册时间:2007-12-18

  • 博文量
    79
  • 访问量
    211215