# Tmax OpenSQL Manual

## Tmax OpenSQL 3.0 manual\_v1.5.0

- [OpenSQL Manual](https://docs.tibero.com/tmaxopensql/opensql-manual.md)
- [목차](https://docs.tibero.com/tmaxopensql/contents.md)
- [OpenSQL 개요](https://docs.tibero.com/tmaxopensql/overview.md)
- [OpenSQL 설치](https://docs.tibero.com/tmaxopensql/installation.md)
- [사전확인사항](https://docs.tibero.com/tmaxopensql/installation/prerequisites.md)
- [OpenSQL 3 바이너리 설치](https://docs.tibero.com/tmaxopensql/installation/binary.md)
- [OpenHA DCS (Distributed Configuration Store)](https://docs.tibero.com/tmaxopensql/installation/binary/openha-dcs-distributed-configuration-store.md)
- [OpenSQL 데이터베이스](https://docs.tibero.com/tmaxopensql/installation/binary/opensql-database.md): OpenSQL 설치를 위한 기본환경 설정 및 PostgreSQL 설치 과정을 안내합니다.
- [OpenHA 클러스터 매니저(OpenHA Cluster Manager)](https://docs.tibero.com/tmaxopensql/installation/binary/openha-cluster-manager.md): OpenHA의 핵심 관리 모듈인 OpenHA 클러스터 매니저(OpenHA Cluster Manager) 설치 과정에 대해서 안내합니다.
- [오픈 프록시(OpenProxy)](https://docs.tibero.com/tmaxopensql/installation/binary/openproxy.md): Rust 기반 서버 프로세스인 오픈프록시(OpenProxy)에 대해 안내합니다.
- [Barman](https://docs.tibero.com/tmaxopensql/installation/binary/barman.md): Python 기반 오픈소스 솔루션인 Barman에 대해 안내합니다.
- [OpenSQL 통합 설치](https://docs.tibero.com/tmaxopensql/installation/binary/opensql.md)
- [Components 설정/실행](https://docs.tibero.com/tmaxopensql/installation/configuration.md)
- [OpenHA DCS (Distributed Configuration Store)](https://docs.tibero.com/tmaxopensql/installation/configuration/openha-dcs.md)
- [OpenHA 클러스터 매니저(OpenHA Cluster Manager)](https://docs.tibero.com/tmaxopensql/installation/configuration/openha-cluster-manager.md): OpenHA의 핵심 관리 모듈인 OpenHA 클러스터 매니저(OpenHA Cluster Manager) 설정, 실행 방법을 안내합니다.
- [오픈 프록시(OpenProxy)](https://docs.tibero.com/tmaxopensql/installation/configuration/openproxy.md): Rust 기반 서버 프로세스인 오픈프록시(OpenProxy) 설정 및 실행에 대해 설명합니다.
- [Barman](https://docs.tibero.com/tmaxopensql/installation/configuration/barman.md): OpenSQL의 효율적인 백업 및 복구를 지원하는 Barman 구성 및 실행방법에 대해 설명합니다.
- [OpenSQL 관리](https://docs.tibero.com/tmaxopensql/administration.md)
- [Patroni 관리](https://docs.tibero.com/tmaxopensql/administration/patroni.md)
- [Etcd 관리](https://docs.tibero.com/tmaxopensql/administration/etcd.md)
- [TLS 인증 구성하기](https://docs.tibero.com/tmaxopensql/administration/etcd/tls-authentication.md)
- [오픈프록시(OpenProxy) 관리](https://docs.tibero.com/tmaxopensql/administration/openproxy.md): 본 문서에서는 OpenProxy의 Connection Pooling, 로드밸런싱, 가상 IP 및 이중화 구성에 대한 설명과 Configuration 파라미터를 통해 해당 기능을 관리하는 방법에 대하여 기술합니다.
- [커넥션 풀(Connection Pool) 관리](https://docs.tibero.com/tmaxopensql/administration/openproxy/connection-pool.md)
- [로드밸런싱 관리](https://docs.tibero.com/tmaxopensql/administration/openproxy/load-balancing.md)
- [가상 IP 및 이중화 구성 관리](https://docs.tibero.com/tmaxopensql/administration/openproxy/virtual-ip-redundancy.md)
- [사용법](https://docs.tibero.com/tmaxopensql/administration/openproxy/undefined.md)
- [O2 Extensions](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions.md): 본 안내서는 OpenSQL을 사용하는 사용자를 대상으로 기술합니다.
- [아키텍처 개요](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/overview.md)
- [설치 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/installation.md)
- [O2 Extension 설치](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/installation/o2-extension.md)
- [참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides.md)
- [스케쥴러(Scheduler) 참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/scheduler.md): DBMS\_JOB, DBMS\_SCHEDULER 패키지 사용을 위한 필수 프레임워크 o2 scheduler에 대한 스케쥴러(scheduler) 참조서입니다.
- [타입(Type) 참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/type.md): 데이터 타입에 대한 참조 안내서입니다.
- [뷰(View) 참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/view.md): 뷰에 대한 참조 안내서입니다.
- [SQL 함수(SQL function) 참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function.md)
- [집계함수(Aggregate Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions.md)
- [LISTAGG](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/listagg.md)
- [MEDIAN](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/median.md)
- [WM\_CONCAT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/wm_concat.md)
- [조건함수(Conditional Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions.md)
- [GREATEST](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/greatest.md)
- [LEAST](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/least.md)
- [LNNVL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/lnnvl.md)
- [NANVL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nanvl.md)
- [NVL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl.md)
- [NVL2](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl2.md)
- [날짜시간함수(DateTime Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions.md)
- [ADD\_MONTHS](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/add_months.md)
- [DBTIMEZONE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/dbtimezone.md)
- [LAST\_DAY](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/last_day.md)
- [MONTHS\_BETWEEN](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/months_between.md)
- [NEXT\_DAY](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/next_day.md)
- [ROUND](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/round.md)
- [SESSIONTIMEZONE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sessiontimezone.md)
- [SYS\_EXTRACT\_UTC](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sys_extract_utc.md)
- [SYSDATE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sysdate.md)
- [SYSTIMESTAMP](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/systimestamp.md)
- [TRUNC](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/trunc.md)
- [NUMTOYMINTERVAL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/numtoyminterval.md)
- [TO\_DSINTERVAL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/to_dsinterval.md)
- [TO\_YMINTERVAL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/to_yminterval.md)
- [Format 함수(Format Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions.md)
- [NUMTODSINTERVAL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/numtodsinterval.md)
- [TO\_CHAR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_char.md)
- [TO\_DATE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_date.md)
- [TO\_MULTI\_BYTE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_multi_byte.md)
- [TO\_NUMBER](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_number.md)
- [TO\_SINGLE\_BYTE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_single_byte.md)
- [TO\_TIMESTAMP\_TZ](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_timestamp_tz.md)
- [UNISTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/unistr.md)
- [Math 함수(Math Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions.md)
- [BITAND](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/bitand.md)
- [COSH](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/cosh.md)
- [MOD](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/mod.md)
- [REMAINDER](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/remainder.md)
- [SINH](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/sinh.md)
- [TANH](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/tanh.md)
- [BIN\_TO\_NUM](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/bin_to_num.md)
- [Misc 함수(Misc Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions.md)
- [SYS\_GUID](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions/sys_guid.md)
- [DUMP](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions/dump.md)
- [텍스트 함수(Text Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions.md)
- [INSTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/instr.md)
- [LENGTH](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/length.md)
- [LPAD](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/lpad.md)
- [LTRIM](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/ltrim.md)
- [NLSSORT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/nlssort.md)
- [REGEXP\_COUNT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_count.md)
- [REGEXP\_INSTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_instr.md)
- [REGEXP\_REPLACE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_replace.md)
- [REGEXP\_LIKE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_like.md)
- [REGEXP\_SUBSTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_substr.md)
- [RPAD](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/rpad.md)
- [RTRIM](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/rtrim.md)
- [SUBSTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/substr.md)
- [ASCIISTR](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/asciistr.md)
- [HEXTORAW](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/hextoraw.md)
- [RAWTONHEX](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/rawtonhex.md)
- [RAWTOHEX](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/text-functions/rawtohex.md)
- [XML 함수(XML Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/xml-xml-functions.md)
- [EXISTSNODE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/xml-xml-functions/existsnode.md)
- [환경 함수(Environment Functions)](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/environment-functions.md)
- [SYS\_CONTEXT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/sql-function/environment-functions/sys_context.md)
- [패키지(Package) 참조 안내서](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package.md): 패키지(Package) 참조 안내서입니다.
- [DBMS\_ALERT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_alert.md)
- [DBMS\_ASSERT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_assert.md)
- [DBMS\_OUTPUT](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_output.md)
- [DBMS\_PIPE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_pipe.md)
- [DBMS\_RANDOM](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_random.md)
- [DBMS\_SQL](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_sql.md)
- [UTL\_FILE](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/utl_file.md)
- [DBMS\_RLS](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_rls.md)
- [DBMS\_JOB](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_job.md)
- [DBMS\_SCHEDULER](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/reference-guides/package/dbms_scheduler.md)
- [TroubleShooting](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/troubleshooting.md)
- [Common Issues](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/troubleshooting/common-issues.md): O2 Extension을 사용하면서 문제가 발생할 경우 수행할 수 있는 조치 방법을 설명합니다.
- [에러 코드](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/troubleshooting/error-code.md)
- [Large Data 처리 가이드](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/troubleshooting/large-data.md)
- [FAQ](https://docs.tibero.com/tmaxopensql/tmax-o2-extensions/troubleshooting/faq.md)
- [Openproxy](https://docs.tibero.com/tmaxopensql/tmax-openproxy.md)
- [Openproxy 사용 설명서](https://docs.tibero.com/tmaxopensql/tmax-openproxy/openproxy.md)
- [OpenProxy 설정 레퍼런스](https://docs.tibero.com/tmaxopensql/tmax-openproxy/tmax-openproxy.md)

## Tmax OpenSQL 3.0 manual\_v1.4.0

- [Tmax OpenSQL Manual](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-opensql-manual.md)
- [목차](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/contents.md)
- [Tmax OpenSQL 개요](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/overview.md)
- [Tmax OpenSQL 설치](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation.md)
- [사전확인사항](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/prerequisites.md)
- [OpenSQL 3 바이너리 설치](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary.md)
- [OpenHA DCS (Distributed Configuration Store)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/openha-dcs-distributed-configuration-store.md)
- [OpenSQL 데이터베이스](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/opensql-database.md): OpenSQL 설치를 위한 기본환경 설정 및 PostgreSQL 설치 과정을 안내합니다.
- [OpenHA 클러스터 매니저(OpenHA Cluster Manager)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/openha-cluster-manager.md): OpenHA의 핵심 관리 모듈인 OpenHA 클러스터 매니저(OpenHA Cluster Manager) 설치 과정에 대해서 안내합니다.
- [오픈 프록시(OpenProxy)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/openproxy.md): Rust 기반 서버 프로세스인 오픈프록시(OpenProxy)에 대해 안내합니다.
- [Barman](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/barman.md): Python 기반 오픈소스 솔루션인 Barman에 대해 안내합니다.
- [OpenSQL 통합 설치](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/binary/opensql.md)
- [Components 설정/실행](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/configuration.md)
- [OpenHA DCS (Distributed Configuration Store)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/configuration/openha-dcs.md)
- [OpenHA 클러스터 매니저(OpenHA Cluster Manager)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/configuration/openha-cluster-manager.md): OpenHA의 핵심 관리 모듈인 OpenHA 클러스터 매니저(OpenHA Cluster Manager) 설정, 실행 방법을 안내합니다.
- [오픈 프록시(OpenProxy)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/configuration/openproxy.md): Rust 기반 서버 프로세스인 오픈프록시(OpenProxy) 설정 및 실행에 대해 설명합니다.
- [Barman](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/installation/configuration/barman.md)
- [Tmax OpenSQL 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration.md)
- [Patroni 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/patroni.md)
- [Etcd 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/etcd.md)
- [TLS 인증 구성하기](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/etcd/tls-authentication.md)
- [오픈프록시(OpenProxy) 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/openproxy.md): 본 문서에서는 OpenProxy의 Connection Pooling, 로드밸런싱, 가상 IP 및 이중화 구성에 대한 설명과 Configuration 파라미터를 통해 해당 기능을 관리하는 방법에 대하여 기술합니다.
- [커넥션 풀(Connection Pool) 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/openproxy/connection-pool.md)
- [로드밸런싱 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/openproxy/load-balancing.md)
- [가상 IP 및 이중화 구성 관리](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/openproxy/virtual-ip-redundancy.md)
- [사용법](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/administration/openproxy/undefined.md)
- [Tmax O2 Extensions](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions.md): 본 안내서는 Tmax OpenSQL을 사용하는 사용자를 대상으로 기술합니다.
- [아키텍처 개요](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/overview.md)
- [설치 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/installation.md)
- [O2 Extension 설치](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/installation/o2-extension.md)
- [참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides.md)
- [스케쥴러(Scheduler) 참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/scheduler.md): DBMS\_JOB, DBMS\_SCHEDULER 패키지 사용을 위한 필수 프레임워크 o2 scheduler에 대한 스케쥴러(scheduler) 참조서입니다.
- [타입(Type) 참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/type.md): 데이터 타입에 대한 참조 안내서입니다.
- [뷰(View) 참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/view.md): 뷰에 대한 참조 안내서입니다.
- [SQL 함수(SQL function) 참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function.md)
- [집계함수(Aggregate Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions.md)
- [LISTAGG](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/listagg.md)
- [MEDIAN](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/median.md)
- [WM\_CONCAT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/wm_concat.md)
- [조건함수(Conditional Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions.md)
- [GREATEST](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/greatest.md)
- [LEAST](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/least.md)
- [LNNVL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/lnnvl.md)
- [NANVL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nanvl.md)
- [NVL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl.md)
- [NVL2](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl2.md)
- [날짜시간함수(DateTime Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions.md)
- [ADD\_MONTHS](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/add_months.md)
- [DBTIMEZONE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/dbtimezone.md)
- [LAST\_DAY](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/last_day.md)
- [MONTHS\_BETWEEN](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/months_between.md)
- [NEXT\_DAY](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/next_day.md)
- [ROUND](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/round.md)
- [SESSIONTIMEZONE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sessiontimezone.md)
- [SYS\_EXTRACT\_UTC](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sys_extract_utc.md)
- [SYSDATE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sysdate.md)
- [SYSTIMESTAMP](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/systimestamp.md)
- [TRUNC](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/trunc.md)
- [NUMTOYMINTERVAL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/numtoyminterval.md)
- [TO\_DSINTERVAL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/to_dsinterval.md)
- [TO\_YMINTERVAL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/to_yminterval.md)
- [Format 함수(Format Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions.md)
- [NUMTODSINTERVAL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/numtodsinterval.md)
- [TO\_CHAR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_char.md)
- [TO\_DATE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_date.md)
- [TO\_MULTI\_BYTE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_multi_byte.md)
- [TO\_NUMBER](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_number.md)
- [TO\_SINGLE\_BYTE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_single_byte.md)
- [TO\_TIMESTAMP\_TZ](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/to_timestamp_tz.md)
- [UNISTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/format-format-functions/unistr.md)
- [Math 함수(Math Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions.md)
- [BITAND](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/bitand.md)
- [COSH](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/cosh.md)
- [MOD](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/mod.md)
- [REMAINDER](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/remainder.md)
- [SINH](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/sinh.md)
- [TANH](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/tanh.md)
- [BIN\_TO\_NUM](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/math-math-functions/bin_to_num.md)
- [Misc 함수(Misc Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions.md)
- [SYS\_GUID](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions/sys_guid.md)
- [DUMP](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/misc-misc-functions/dump.md)
- [텍스트 함수(Text Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions.md)
- [INSTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/instr.md)
- [LENGTH](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/length.md)
- [LPAD](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/lpad.md)
- [LTRIM](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/ltrim.md)
- [NLSSORT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/nlssort.md)
- [REGEXP\_COUNT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_count.md)
- [REGEXP\_INSTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_instr.md)
- [REGEXP\_REPLACE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_replace.md)
- [REGEXP\_LIKE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_like.md)
- [REGEXP\_SUBSTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_substr.md)
- [RPAD](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/rpad.md)
- [RTRIM](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/rtrim.md)
- [SUBSTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/substr.md)
- [ASCIISTR](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/asciistr.md)
- [HEXTORAW](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/hextoraw.md)
- [RAWTONHEX](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/rawtonhex.md)
- [RAWTOHEX](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/text-functions/rawtohex.md)
- [XML 함수(XML Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/xml-xml-functions.md)
- [EXISTSNODE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/xml-xml-functions/existsnode.md)
- [환경 함수(Environment Functions)](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/environment-functions.md)
- [SYS\_CONTEXT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/sql-function/environment-functions/sys_context.md)
- [패키지(Package) 참조 안내서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package.md): 패키지(Package) 참조 안내서입니다.
- [DBMS\_ALERT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_alert.md)
- [DBMS\_ASSERT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_assert.md)
- [DBMS\_OUTPUT](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_output.md)
- [DBMS\_PIPE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_pipe.md)
- [DBMS\_RANDOM](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_random.md)
- [DBMS\_SQL](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_sql.md)
- [UTL\_FILE](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/utl_file.md)
- [DBMS\_RLS](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_rls.md)
- [DBMS\_JOB](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_job.md)
- [DBMS\_SCHEDULER](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/reference-guides/package/dbms_scheduler.md)
- [TroubleShooting](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/troubleshooting.md)
- [Common Issues](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/troubleshooting/common-issues.md): O2 Extension을 사용하면서 문제가 발생할 경우 수행할 수 있는 조치 방법을 설명합니다.
- [에러 코드](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/troubleshooting/error-code.md)
- [Large Data 처리 가이드](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/troubleshooting/large-data.md)
- [FAQ](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-o2-extensions/troubleshooting/faq.md)
- [Tmax Openproxy](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-openproxy.md)
- [Openproxy 사용 설명서](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-openproxy/openproxy.md)
- [Tmax OpenProxy 설정 레퍼런스](https://docs.tibero.com/tmaxopensql/3.0_v.1.4.0_manual/tmax-openproxy/tmax-openproxy.md)

## Release Notes

- [릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote.md): OpenSQL 릴리즈 노트를 통해 신규 업데이트 사항을 확인하세요.
- [1.0.0 릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote/1.0.0.md)
- [1.1.0 릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote/1.1.0.md)
- [1.2.0 릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote/1.2.0.md)
- [1.3.0 릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote/1.3.0.md)
- [1.4.0 릴리즈 노트](https://docs.tibero.com/tmaxopensql/releasenote/releasenote/1.4.0.md)
- [OpenProxy](https://docs.tibero.com/tmaxopensql/releasenote/openproxy.md): OpenSQL의 OpenProxy 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [Openproxy - 1.0](https://docs.tibero.com/tmaxopensql/releasenote/openproxy/openproxy-1.0.md): OpenSQL 3.0의 1.0 버전 매뉴얼에 언급된 OpenProxy 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [Openproxy - 1.1](https://docs.tibero.com/tmaxopensql/releasenote/openproxy/openproxy-1.1.md)
- [Copy of 1.0](https://docs.tibero.com/tmaxopensql/releasenote/openproxy/copy-of-1.0.md): OpenSQL 3.0의 1.0 버전 매뉴얼에 언급된 OpenProxy 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [O2 Extensions](https://docs.tibero.com/tmaxopensql/releasenote/o2-extensions.md): OpenSQL의 O2 Extensions 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [O2 - 1.0](https://docs.tibero.com/tmaxopensql/releasenote/o2-extensions/o2-1.0.md): OpenSQL 3.0의 1.0 버전 매뉴얼에 언급된 O2 Extensions 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [O2 - 1.1](https://docs.tibero.com/tmaxopensql/releasenote/o2-extensions/o2-1.1.md): OpenSQL 3.0의 1.1 버전 매뉴얼에 언급된 O2 Extensions 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [O2 - 1.2](https://docs.tibero.com/tmaxopensql/releasenote/o2-extensions/o2-1.2.md): OpenSQL 3.0의 1.2 버전 매뉴얼에 언급된 O2 Extensions 관련 기능 추가 및 개선된 사항에 대해 안내합니다.
- [O2 - 1.3](https://docs.tibero.com/tmaxopensql/releasenote/o2-extensions/o2-1.3.md): OpenSQL 3.0의 1.3 버전 매뉴얼에 언급된 O2 Extensions 관련 기능 추가 및 개선된 사항에 대해 안내합니다.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on a page URL with the `ask` query parameter:
```
GET https://docs.tibero.com/tmaxopensql/opensql-manual.md?ask=<question>
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.