개인적인 정리

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

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