개인적인 정리

오라클 POWER() POWER() - 제곱에 대한 표현 POWER(n2, n1) 의 형태 POWER returns n2 raised to the n1 power. The n2 and the exponent n1 can be any numbers, but if n2 is negative, then n1 must be an integer. 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 ..

오라클 PERCENT_RANK() PERCENT_RANK() - PERCENT_RANK(expr) WITHIN GROUP(ORDER BY expr DESC|ASC NULLS FIRST|LAST) PERCENT_RANK() OVER (query_partition_clause order_by_clause) 의 형태 PERCENT_RANK is similar to the CUME_DIST(cumulative distribution) function. The range of values returned by PERCENT_RANK is 0 to 1. inclusive. The first row in any set has a PERCENT_RANK of 0. The return value is NUMBER. As..

오라클 NVL2() NVL2() - NVL2(expr1, expr2, expr3) 의 형태 NVL2 let you determine the value returned by a query based on whether a specified expression is null or not null. If expr1 is not null, then NVL2 returns expr2, if expr1 is null, then NVL2 returns expr3. The argument expr1 can have any data type. The arguments expr2 and expr3 can have any data types except LONG. If the data types expr2 and expr3..

오라클 NVL() NVL() - NVL(expr1, expr2) 의 형태 NVL lets you replace null(returned as a blank) with a string in the results of a query. If expr1 is null, the NVL returns expr2. If expr1 is not null, then NVL returns expr1. The argument expr1 and expr2 can have day data type. If their data types are different, then Oracle Database implictily converts one to the other. If they cannot be converted implici..

오라클 NUMTOYMINTERVAL() NUMTOYMINTERVAL() - NUMTOYMINTERVAL(n, interval_unit) 의 형태 NUMTOYMINTERVAL converts number n to an INTERVAL YEAR TO MONTH literal. The argument n can be any NUMBER value or an expression that can be implicitly convrted to a NUMBER value. The argument interval_unit can be of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type. The value for interval_unit specified the unit of n an..

오라클 NUMTODSINTERVAL() NUMTODSINTERVAL() - NUMTODSINTERVAL(n, interval_unit) 의 형태 NUMTODSINTERVAL converts n to an INTERVAL DAY TO SECOND literal. The argument n can be any NUMBER value or an expression that can be implicitly converts to a NUMBER value. The argument interval_unit can be of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type. The value for interval_unit specified the unit of n and must ..

오라클 NULLIF() NULLIF() - NULLIF(expr1, expr2) 의 형태 NULLIF compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1. You cannot specify the literal NULL for expr1. If both arguments are numeric data types, then Oracle Database determines the argument with the higher numeric precedence, implicitly converts the other argument..

오라클 NTILE() NTILE() - NTILE(expr) OVER (query_partition_clause order_by_clause) 의 형태 NTILE is an analytic function. It devides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row. The buckets are numbered 1 throguh expr. The expr value must resolve to a positive constant for each partition. Oracle Database expects an integer, and i..