* format model : http://goo.gl/9fKed
: a character literal that describes the format of datetime or numeric data stored in a character string
* format elements
* format model modifiers: toggle
- fm (fill mode): no leading or trailing blanks in format elements
<= TO_CHAR
- fx (format exact): exact matching between the character data and the format model
<= TO_DATE
-----------------
-----------------
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
6일차 # 3-38: TO_CHAR with Numbers (0) | 2012.04.10 |
---|---|
6일차 # 3-37: fm의 효과 (0) | 2012.04.10 |
6일차 # 3-29: Explicit conversion (0) | 2012.04.10 |
6일차 * 자동 변환과 인덱스 (0) | 2012.04.10 |
6일차 * 3-28: For expression evaluation (0) | 2012.04.10 |