개인적인 정리

오라클 ATAN() ATAN return the arc tangent of n. The argument n can be in an unbounded range and returns a value in the range of -pi / 2to pi /2, expressed in radians. SQL> SELECT ATAN(-2) FROM DUAL ; --> -1.10714871779409

오라클 ASIN 함수 ASIN returns the are sine of n. The argument n must be in the range of -1 to 1, and the function returns a value in the range of -pi / 2 to pi / 2, exrpessed in radians. SQL> SELECT ASIN(.3) FROM DUAL ; --> 0.304692654015398 SQL> SELECT ASIN(-2) FROM DUAL ; --> ORA-01428: argument '-2' is out of range 라는 오류가 발생.

오라클 ASCIISTR 함수 ASCIISTR takes as its argument a string, or an expression that resolves to a string, in any character set and return an ASCII version of the string in the database character set.

오라클에서 ASCII() 함수 ASCII returns the decimal representation(십진 표기법) in the database character set of the first character of char SQL > SELECT last_name FROM employees WHERE ASCII(SUBSTR(last_name, 1, 1)) =76 ORDER BY last_name ; --> Ladwig Landry Lee Livingston Lorentz SQL> SELECT ASCII('\?') FROM DUAL; --> 92

오라클에 XML 관련 함수들이 있다. APPENDCHILDXML DELETEXML DEPTH EXISTSNODE EXTRACT (XML) EXTRACTVALUE INSERTCHILDXML INSERTCHILDXMLAFTER INSERTCHILDXMLBEFORE INSERTXMLAFTER INSERTXMLBEFORE PATH SYS_DBURIGEN SYS_XMLAGG SYS_XMLGEN UPDATEXML XMLAGG XMLCAST XMLCDATA XMLCOLATTVAL XMLCOMMENT XMLCONCAT XMLDIFF XMLELEMENT XMLEXISTS XMLFOREST XMLISVALID XMLPARSE XMLPATCH XMLPI XMLQUERY XMLROOT XMLSEQUENCE XMLSERIALI..

ADD_MONTHS(date, integer) - date 에 integer 를 더한 date를 return 한다. integer는 =, - 모두 가능 ADD_MONTHS returns the date date plus integer months. A month is defined by the session parameter NLS_CALENDAR. The date argument can be a datetime value or any value that can be implicitly converted to DATE. The integer agrument can be an integer or any value that can be implicitly converted to an integer. The ..

ACOS(n) ACOS returns the arc cosine of n. the argument n must be in the range of -1 to 1, and the function returns a value in the range of 0 to pi, expressed in radians. SQL> SELECT ACOS(.3) FROM DUAL ; --> 1.2661036727795

ABS(n) ABS returns the absolute value of n. 절대값을 return SQL>SELECT ABS('-1000.99999') FROM DUAL ; --> 1000.99999 SQL>SELECT ABS('A') FROM DUAL ; --> ORA-01722: invalid number 를 발생시킨다.