개인적인 정리

오라클 max() MAX() - max 값을 return. aggregate 또는 anlaytic 함수로 사용가능 (집계함수, 분석함수 정도) MAX( expr) MAX( expr) OVER (analytic_clause) MAX( [DISTINCT|ALL] expr) MAX( [DISTINCT|ALL] expr) OVER (analytic_clause) 의 형태 MAX returns maximum value of expr. You can use it as a aggregate or analytic function. 오라클 OE 계정으로 테스트 할 수 있다. SQL > SELECT MAX(salary) "Max" FROM employees ; --> 24000 SQL>SELECT manager_id, l..

오라클 LTRIM() LTRIM() - LTRIM(char) LTRIM(char, set) 의 형태 LTRIM removes from the left end of char all of the characters contained in set. If you do not specify set, then it defaults to a single blnak. If char is a character literal, then you must enclose it in single quotation marks. Oracle Database begins scanning char from its first character and removes all characters that apper in set until re..

오라클 LPAD() LPAD() - LPAD(expr1, n) LPAD(expr1, n, expr2) 의 형태 LPAD returns expr1, left-padded to length n characters with the sequence of characters in expr2. This function is useful for formatting the output of a query. Both expr1 and expr2 can be any of data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The string returned is of VARCHAR2 data type if expr1 is a character data type, N..

오라클 LOWER() LOWER() - 문자열을 소문자로 바꿔주는 함수 LOWER(char) 의 형태 LOWER returns char, with all letters lowercase. char can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB or NCLOB. The return value is the same data type as char. The database sets the case of the chracters based on the binary mapping defined for the underlying character set. For linguistic-sensitive lowercase, refer to NLS..

오라클 LOG() LOG() - LOG(n2, n1) 의 형태 LOG returns the logarithm, base n2, of n1. The base n1 can be any positive value other 0 or 1 and n2 can be any positive value. This function takes as arguments any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. If any argument is BINARY_FLOAT, or BINARY_DOUBLE, then the function returns BINARY_DOUBLE. Oth..

오라클 LOCALTIMESTAMP() LOCALTIMESTAMP() - LOCALTIMESTAMP(timestamp_precision) 의 형태 LOCALTIMESTAMP returns the current date and time in the session time zone in a value of data type TIMESTAMP. The difference between this function and CURRENT_TIMESTAMP is that LOCALTIMESTAMP returns a TIMESTAMP value while CURRENT_TIMESTAMP returns TIMESTAMP WITH TIME ZONE value. The optional argument timestamp_prec..

오라클 LNNVL() LNNVL() - 조건이 UNKNOWN 이나 FALSE 이면 TRUE 를 return ?? - NOT IN 또는 NOT EXISTS 와 유사하면서 조금 다른 느낌정도 ? - 예제를 봐야 이해가 된다. - 사실 처음봐서 횡설 수설... LNNVL(condition) 의 형태 LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used in the WHERE clause of a query, or as the WHEN condition in a searched CASE expression. It takes as..

오라클 LN() LN() - 자연로그값을 구해주는 것 같은데.. 자연로그만 말을 써본지가 언젠지 싶다. LN(n) 의 형태 LN returns the natural logarithm of n, where n is greate than 0. SQL> SELECT LN(95) FROM DUAL ; --> 4.55387689160054