개인적인 정리

오라클 LEAST() LEAST() - 여러개의 인자들 사이에서 가장 작은값을 return. LEAST(expr1, expr2....) 의 형태 LEAST returns the least of a list of one or more expressions. Oracle Database uses the first expr to determine the return type. If the first expr is numeric, then Oracle determines the argument with the highest numeric precedence, implicitly converts the remaining arguments to that data type before the comparison, a..

오라클 LEAD() LEAD() - LEAD(value_expr, offset) RESPECT | IGNORE NULLS OVER (query_partition_clause order_by_clause) LEAD(value_expr RESPECT NULLS, 1) OVER (query_partition_clause order_by_clause) LEAD(value_expr, 1) OVER (query_partition_clause order_by_clause) 의 형태 LEAD is an analytic function. It provides access to more than one row of a table at the same time without a self join. Given a series..

오라클 LAST_VALUE() LAST_VALUE() - LAST_VALUE(expr) OVER (analytic_clause) LAST_VALUE(expr RESPECT|IGNORE NULL) OVER (analytic_clause) 의 형태 LAST_VALUE is an analytic function that is useful for data densification. It returns the last value in an ordered set of values. {RESPECT | IGNORE} NULLS determine whether null values of expr are included in or eliminated from the calculation. the default is RE..

오라클 LAST_DAY() LAST_DAY() - 달의 마지막 날짜를 구해준다. LAST_DAY(date) 의 형태 LAST_DAY returns the date of the last day of the month that contains date. The last day of the month is defined by the session parameter NLS_CALENDAR. The return type is always DATE, regardless of the data type of date. SQL> SELECT LAST_DAY(SYSDATE) FROM DUAL ; --> 2020/04/30 오후 2:42:01 SQL> SELECT LAST_DAY('2020-04-01') FROM DUAL;..

오라클 LAST() LAST() 함수는 FIRST() 함수를 참조한다. https://web-obj.tistory.com/393 ORACLE FIRST() 오라클 FIRST() 이런 함수가 있는지 처음 알았다. FIRST AND LAST are very similar functions. Both are aggregate and analytic functions that operate on a set of values from a set of rows that rank as th.. web-obj.tistory.com

오라클 INSTR() INSTR() - 문자열과 비교하여 문자열의 위치를 return 해준다. - 비교할 문자열의 위치와, 발견횟수등을 정하여서도 사용이 가능하다. (position, occurence) - 검색관련해서도 사용가능 INSTR(string, substring) INSTR(string, substring, position, occurence) 의 형태 The INSTR functions search string for substring. The search operation is defined as comparing the substring argument with substrings of string of the same length for equality until a match is f..

오라클 INSERTCHILDXML) INSERTCHILDXML() - INSERTCHILDXML inserts a user-supplied value into the target XML at the note indicated by the XPath expression.

오라클 INITCAP() INITCAP() - INITCAP(char) 의 형태 INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. char can be of any of the data type CHAR, VARCHAR2, NCHAR, or NVARCHAR2. The return value is the same data type as char. The database set the case of the initial characters b..