일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 |
- jquery
- java
- exception
- 오라클
- 스크립트
- maven
- 톰캣
- RADIO
- 전자정부 표준프레임워크
- html
- 이클립스
- Oracle
- 날짜
- @RequestBody
- json
- 네이버스마트 에디터
- 문자열
- MYSQL
- php
- DB
- spring form tag
- 호환성
- 한글
- SSL
- 웹 플랫폼 설치 관리자
- HTML5
- switch
- null
- JSTL
- checbox
- Today
- Total
목록분류 전체보기 (525)
개인적인 정리
오라클 RTRIM() RTRIM() - RTRIM(char, set) 의 형태 RTRIM removes from the right end of char all of the characters that appear in set. This function is useful for formatting the output of a query. If you do not specify set, then it defaults to a single blank. If char is a character literal, then you must enclose it in single quotation marks. RTRIM works sililarly to LTRIM. Both char and set can be any o..
오라클 RPAD() RPAD() - RPAD(expr1, n, expr2) 의 형태 RPAD returns expr1, right-padded to length n characters with expr2, replicated as many times as necessary. This function is useful for formatting the output of a query. Both expr1 and expr2 can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 data type, and a LOB if expr1 is a LOB data typ..
오라클 ROW_NUMBER() ROW_NUMBER() - ROW_NUMBER() OVER (query_partition_clause order_by_clause) 의 형태 ROW_NUMBER is an analytic function. It assigns a unique number to each row to which it is applied (either each row in the partition or each row returned by the query), in the ordered sequence of rows specified in the order_by_clause, beginning with 1. By nesting a subquery using ROW_NUMBER inside a qu..
오라클 ROUND(number) ROUND(number) - ROUND(n) ROUND(n, integer) 의 형태 ROUND returns n rounded to integer places to the right of the decimal point. If you omit integer, then n is rounded to zero places. If integer is negative, then n is rounded off to the left of the decimal point. n can be any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. If y..
오라클 ROUND(date) ROUND(date) - ROUND(date) ROUND(date, fmt) 의 형태 ROUND returns date rounded to the unit specified by the format model fmt. The function is not sensitive to the NLS_CALENDAR session parameter. It operates according to the rules of the Gregorian calendar. The value returned is always of data type DATA, even if you specify a different datetime data type for date. If you moit fmt, the..
오라클 REPLACE REPLACE() - REPLACE(char, search_string) REPLACE(char, search_string, replacement_string) 의 형태 REPLACE returns char with every occurence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occurence of search_string are removed. If search_string is null, then char is returned. Both search_string and replacement_string, as well as char..
오라클 REMAINDER REMAINDER - REMAINDER(n2, n1) 의 형태 REMAINDER returns the remainder of n2 divided by n1. This function takes as arguments any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type, and returns theat data ty..