개인적인 정리

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

오라클 NTH_VALUE() NTH_VALUE() - NTH_VALUE(measure_expr, n) FROM [FIRST | LAST] [RESPECT | IGNORE] NULLS OVER (analytic_clause) 의 형태 NTH_VALUE returns the measure_expr value of the nth row in the window defined by the analytic_clause. The returned value has the data type of the measure_expr. [RESPECT | IGNORE] NULLS determines whether null values of measure_expr are included in or eliminated from t..

오라클 NEXT_DAY() NEXT_DAY() - arugment로 전달된 date의 다음주의 명시된 요일의 date 를 구하는 함수. - 다음주 화요일의 날짜를 구하는 함수 ?? NEXT_DAY(date, char) 의 형태 NEXT_DAY returns the date of the first weekday named by char that is later than the date date. The return type is always DATE, regardless of the data type of date. The argument char must be a day of the week in the date language of your session, either the full name or t..

오라클 NCHR() NCHR() - NCHR(number) 의 형태 NCHR returns the character having the binary equivalent to number in the national character set. The value returned is always NVARCHAR2. This function is equivalent to using the CHR function with the USING NCHAR_CS clause. This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER, and returns a character. SQL>..