2013년 6월 11일 화요일

oracle - special pattern-matching characters

oracle LIKE condition 중 special pattern-matching characters는 아래 두 가지가 있다.


  • An underscore (_) in the pattern matches exactly one character (as opposed to one byte in a multibyte character set) in the value.
  • A percent sign (%) in the pattern can match zero or more characters (as opposed to bytes in a multibyte character set) in the value. The pattern '%' cannot match a null.

댓글 없음:

댓글 쓰기