일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 | 29 | 30 | 31 |
- JSTL
- DB
- 톰캣
- 스크립트
- 이클립스
- checbox
- Oracle
- 오라클
- 한글
- java
- HTML5
- 웹 플랫폼 설치 관리자
- SSL
- switch
- RADIO
- maven
- jquery
- exception
- 네이버스마트 에디터
- 날짜
- 문자열
- MYSQL
- 전자정부 표준프레임워크
- 호환성
- null
- spring form tag
- @RequestBody
- php
- html
- json
- Today
- Total
목록DB/ORACLE (101)
개인적인 정리
오라클 NTH_VALUE() NTH_VALUE() - NTH_VALUE(measure_expr, n) FROM [FIRST | LAST] [RESPECT | IGNORE] NULLS OVER (analytic_clause) 의 형태 NTH_VALUE returns the measure_expr value of the nth row in the window defined by the analytic_clause. The returned value has the data type of the measure_expr. [RESPECT | IGNORE] NULLS determines whether null values of measure_expr are included in or eliminated from t..
오라클 NEXT_DAY() NEXT_DAY() - arugment로 전달된 date의 다음주의 명시된 요일의 date 를 구하는 함수. - 다음주 화요일의 날짜를 구하는 함수 ?? NEXT_DAY(date, char) 의 형태 NEXT_DAY returns the date of the first weekday named by char that is later than the date date. The return type is always DATE, regardless of the data type of date. The argument char must be a day of the week in the date language of your session, either the full name or t..
오라클 NCHR() NCHR() - NCHR(number) 의 형태 NCHR returns the character having the binary equivalent to number in the national character set. The value returned is always NVARCHAR2. This function is equivalent to using the CHR function with the USING NCHAR_CS clause. This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER, and returns a character. SQL>..
오라클 NANVL() NANVL() - NANVL(n2 ,n1) 의 형태 The NANVL function is useful only for floating-point numbers of type BINARY_FLOAT or BINARY_DOUBLE. it instructs Oracle Database to return an alternative value n1 if the input value n2 is NAN(not a number). If n2 is not NaN. then Oracle returns n2. This function takes as arguments any numeric data type or any nonumeric data type that can be implicitly con..
오라클 MONTHS_BETWEEN() MONTHS_BETWEEN() - MONTHS_BETWEEN(date1, date2) 의 형태 MONTHS_BETWEEN returns number of months between dates date1 and date2. The month and the last day of the month are defined by the parameter NLS_CAENDAR. If date1 is later than date2, then the result is positive. If date1 is earlier than date2, then the result is negative. If date1 and date2 are either the same days of the ..
오라클 MOD() MOD() - MOD(n2, n1) 의 형태 MOD returns the remainder of n2 divided by n1. Returns n2 if n1 is 0. 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 that data ..
오라클 MIN() MIN() - 최소값을 구하는 함수. MIN(expr) MIN(expr) OVER (analytic_clause) MIN([DISTINCT | ALL] expr) MIN([DISTINCT | ALL] expr) OVER (analytic_clause) 의 형태 DISTINCT, ALL 은 생략가능. MIN returns minimum value of expr. You can use it as an aggregate or analytic function. 오라클 HR, OE 계정으로 테스트 가능 SQL> SELECT MIN(hire_date) FROM employees ; -->2001/01/13 SQL>SELECT manager_id, last_name, hire_date, salary..
오라클 MEDIAN MEDIAN() - 분포된 값들에서 중간값 정도를 return 해주는 것 같다. - 처음보는 함수이다. MEDIAN(expr) MEDIAN(expr) OVER (query_partition_clause) 의 형태 MEDIAN is an inverse distribution function that assumes a continuous distribution model. It takes a numeric or datetime value and returns the middle value or an interpolated value that would be the middle value once the values are sorted. Nulls are ignored in the calc..