개인적인 정리

오라클 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

오라클 LISTAGG() LISTAGG() - LISTAGG(measure_expr, 'delimiter') WITHIN GROUP(order_by_clause), LISTAGG(measure_expr, 'delimiter') WITHIN GROUP(order_by_clause) OVER query_partition_clause 의 형태 For a specified measure, LISTAGG orders data within each group specified in the ORDER BY clause and then concatenates the values of the measure column. As a single-set aggregate function, LISTAGG operates on ..

오라클 LENGTH() LENGTH() - 문자열의 길이를 구해주는 함수 LENGTH(char) 의 형태 The LENGTH functions return the length of char. LENGTH calculates length using caracters as defined by the input character set. LENGTHB uses bytes instead of charactes. LENGTHC uses Unicode complete characters. LENGTH2 uses UCS2 code points. LENGTH4 uses UCS4 code points. char can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2..

오라클 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..