티베로(Tibero)제공 함수 정리 - 티멕스 제공

티베로 제공함수

1. 분석함수

티베로제공 분석 함수(analytic_fnnction)

2. 함수 목록

2.1. ABS
2.2. ACOS
2.3. ADD_MONTHS
2. AGGR_CONCAT
2.5. APPENDCHILDXML
2.6. ASCII
2.7. ASCIISTR
2.8. ASIN
2.9. ATAN
2.10. ATAN2
2.11. AVG
2.12. BITAND
2.13. CAST
2.1 CEIL
2.15. CHARTOROWID
2.16. CHR
2.17. COALESCE
2.18. COMPOSE
2.19. CONCAT
2.20. CONVERT
2.21. CORR
2.22. COS
2.23. COSH
2.2 COUNT
2.25. COVAR_POP
2.26. COVAR_SAMP
2.27. CUME_DIST
2.28. CURRENT_DATE
2.29. CURRENT_TIME
2.30. CURRENT_TIMESTAMP
2.31. DBTIMEZONE
2.32. DECODE
2.33. DECOMPOSE
2.3 DELETEXML
2.35. DENSE_RANK
2.36. DUMP
2.37. EMPTY_BLOB
2.38. EMPTY_CLOB
2.39. EXISTSNODE
2.40. EXP
2.41. EXTRACT
2.42. EXTRACT(XML)
2.43. EXTRACTVALUE
2.4 FIRST
2.45. FIRST_VALUE
2.46. FLOOR
2.47. FROM_TZ
2.48. GETBLOBVAL
2.49. GETCLOBVAL
2.50. GETROOTELEMENT
2.51. GETSTRINGVAL
2.52. GREATEST
2.53. GROUPING
2.5 GROUPING_ID
2.55. GROUP_ID
2.56. HEXTORAW
2.57. INET_ATON
2.58. INET_NTOA
2.59. INITCAP
2.60. INSERTCHILDXML
2.61. INSERTCHILDXMLAFTER
2.62. INSERTCHILDXMLBEFORE
2.63. INSERTXMLAFTER
2.6 INSERTXMLBEFORE
2.65. INSTR
2.66. ISFRAGMENT
2.67. KURT
2.68. LAG
2.69. LAST_DAY
2.70. LAST
2.71. LAST_VALUE
2.72. LEAD
2.73. LEAST
2.7 LENGTH
2.75. LISTAGG
2.76. LN
2.77. LNNVL
2.78. LOCALTIMESTAMP
2.79. LOG
2.80. LOWER
2.81. LPAD
2.82. LTRIM
2.83. MAX
2.8 MEDIAN
2.85. MIN
2.86. MOD
2.87. MONTHS_BETWEEN
2.88. NANVL
2.89. NEW_TIME
2.90. NEXT_DAY
2.91. NLSSORT
2.92. NLS_CHARSET_ID
2.93. NLS_INITCAP
2.9 NLS_LOWER
2.95. NLS_UPPER
2.96. NTILE
2.97. NULLIF
2.98. NUMTODSINTERVAL
2.99. NUMTOYMINTERVAL
2.100. NVL
2.101. NVL2
2.102. ORA_HASH
2.103. OVERLAPS
2.10 PERCENT_RANK
2.105. PERCENTILE_CONT
2.106. PERCENTILE_DISC
2.107. POWER
2.108. RANK
2.109. REGR_SLOPE
2.110. REGR_INTERCEPT
2.111. REGR_COUNT
2.112. REGR_R2
2.113. REGR_AVGX
2.11 REGR_AVGY
2.115. REGR_SXX
2.116. REGR_SYY
2.117. REGR_SXY
2.118. RATIO_TO_REPORT
2.119. RAWTOHEX
2.120. REGEXP_COUNT
2.121. REGEXP_INSTR
2.122. REGEXP_REPLACE
2.123. REGEXP_SUBSTR
2.12 REMAINDER
2.125. REPLACE
2.126. REVERSE
2.127. ROUND(number)
2.128. ROUND(date)
2.129. ROWIDTOCHAR
2.130. ROW_NUMBER
2.131. RPAD
2.132. RTRIM
2.133. SESSIONTIMEZONE
2.13 SIGN
2.135. SIN
2.136. SINH
2.137. SKEW
2.138. SQRT
2.139. STDDEV
2.140. STDDEV_POP
2.141. STDDEV_SAMP
2.142. SUBSTR
2.143. SUM
2.14 SYS_CONNECT_BY_PATH
2.145. SYS_CONTEXT
2.146. SYS_EXTRACT_UTC
2.147. SYS_GUID
2.148. SYSDATE
2.149. SYSTIME
2.150. SYSTIMESTAMP
2.151. TAN
2.152. TANH
2.153. TIMESTAMP_TO_TSN
2.15 TO_BINARY_DOUBLE
2.155. TO_BINARY_FLOAT
2.156. TO_BLOB
2.157. TO_CHAR(character)
2.158. TO_CHAR(datetime)
2.159. TO_CHAR(number)
2.160. TO_CLOB
2.161. TO_DATE
2.162. TO_DSINTERVAL
2.163. TO_LOB
2.16 TO_MULTI_BYTE
2.165. TO_NCHAR
2.166. TO_NUMBER
2.167. TO_SINGLE_BYTE
2.168. TO_TIME
2.169. TO_TIMESTAMP
2.170. TO_TIMESTAMP_TZ
2.171. TO_YMINTERVAL
2.172. TRANSLATE
2.173. TRIM
2.17 TRUNC(number)
2.175. TRUNC(date)
2.176. TSN_TO_TIMESTAMP
2.177. TZ_OFFSET
2.178. TZ_SHIFT
2.179. UID
2.180. UNISTR
2.181. UPDATEXML
2.182. UPPER
2.183. USER
2.18 USERENV
2.185. VAR_POP
2.186. VAR_SAMP
2.187. VARIANCE
2.188. VSIZE
2.189. XMLAGG
2.190. XMLCAST
2.191. XMLCDATA
2.192. XMLCOLATTVAL
2.193. XMLCOMMENT
2.19 XMLCONCAT
2.195. XMLELEMENT
2.196. XMLEXISTS
2.197. XMLFOREST
2.198. XMLPARSE
2.199. XMLPI
2.200. XMLQUERY
2.201. XMLROOT
2.202. XMLSERIALIZE
2.203. XMLSEQUENCE
2.20 XMLTABLE
2.205. XMLTRANSFORM

[출처] tmaxsoft.com
https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20150504-000001/sql-reference/ch_SQL_functions.html