# En\_Tmax OpenSQL Manual

## En\_Tmax OpenSQL 안내서 v1.0.0

- [Tmax OpenSQL Manual](https://docs.tibero.com/tmaxopensql.en/tmax-opensql-manual.md)
- [Tmax OpenSQL Overview](https://docs.tibero.com/tmaxopensql.en/overview.md)
- [Tmax OpenSQL Installation](https://docs.tibero.com/tmaxopensql.en/installation.md)
- [Prerequisites](https://docs.tibero.com/tmaxopensql.en/installation/prerequisites.md)
- [OpenSQL 3.0 binary installation](https://docs.tibero.com/tmaxopensql.en/installation/opensql-3.0-binary-installation.md)
- [Etcd](https://docs.tibero.com/tmaxopensql.en/installation/opensql-3.0-binary-installation/etcd.md)
- [Postgresql](https://docs.tibero.com/tmaxopensql.en/installation/opensql-3.0-binary-installation/postgresql.md)
- [Patroni](https://docs.tibero.com/tmaxopensql.en/installation/opensql-3.0-binary-installation/patroni.md)
- [OpenProxy](https://docs.tibero.com/tmaxopensql.en/installation/opensql-3.0-binary-installation/openproxy.md)
- [Components configuration](https://docs.tibero.com/tmaxopensql.en/installation/configuration.md)
- [Etcd](https://docs.tibero.com/tmaxopensql.en/installation/configuration/etcd.md): This section describes how to set up and run etcd, which stores OpenSQL's cluster configuration information and settings.
- [Patroni](https://docs.tibero.com/tmaxopensql.en/installation/configuration/patroni.md)
- [OpenProxy](https://docs.tibero.com/tmaxopensql.en/installation/configuration/openproxy.md)
- [Tmax OpenSQL Administration](https://docs.tibero.com/tmaxopensql.en/administration.md)
- [Patroni](https://docs.tibero.com/tmaxopensql.en/administration/patroni.md)
- [Etcd](https://docs.tibero.com/tmaxopensql.en/administration/etcd.md)
- [TLS authentication](https://docs.tibero.com/tmaxopensql.en/administration/etcd/tls-authentication.md)
- [OpenProxy](https://docs.tibero.com/tmaxopensql.en/administration/openproxy.md)
- [Connection pool](https://docs.tibero.com/tmaxopensql.en/administration/openproxy/connection-pool.md)
- [Load balancing](https://docs.tibero.com/tmaxopensql.en/administration/openproxy/load-balancing.md)
- [Virtual IP and Redundancy](https://docs.tibero.com/tmaxopensql.en/administration/openproxy/virtual-ip-redundancy.md)
- [Tmax O2 Extensions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions.md): This guide is intended for users of Tmax OpenSQL.
- [Architecture Overview](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/overview.md)
- [Installation](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/installation.md)
- [O2 Extension Installation](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/installation/o2-extension-installation.md)
- [Reference guide](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides.md)
- [Type](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/type.md)
- [View](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/view.md)
- [SQL function](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function.md)
- [Aggregate Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions.md)
- [LISTAGG](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/listagg.md)
- [MEDIAN](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/median.md)
- [WM\_CONCAT](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/aggregate-functions/wm_concat.md)
- [Conditional Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions.md)
- [GREATEST](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/greatest.md)
- [LEAST](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/least.md)
- [LNNVL](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/lnnvl.md)
- [NANVL](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nanvl.md)
- [NVL](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl.md)
- [NVL2](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/conditional-functions/nvl2.md)
- [DateTime Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions.md)
- [ADD\_MONTHS](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/add_months.md)
- [DBTIMEZONE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/dbtimezone.md)
- [LAST\_DAY](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/last_day.md)
- [MONTHS\_BETWEEN](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/months_between.md)
- [NEXT\_DAY](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/next_day.md)
- [ROUND](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/round.md)
- [SESSIONTIMEZONE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sessiontimezone.md)
- [SYS\_EXTRACT\_UTC](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sys_extract_utc.md)
- [SYSDATE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/sysdate.md)
- [SYSTIMESTAMP](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/systimestamp.md)
- [TRUNC](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/datetime-functions/trunc.md)
- [Format Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions.md)
- [NUMTODSINTERVAL](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/numtodsinterval.md)
- [TO\_CHAR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_char.md)
- [TO\_DATE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_date.md)
- [TO\_MULTI\_BYTE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_multi_byte.md)
- [TO\_NUMBER](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_number.md)
- [TO\_SINGLE\_BYTE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_single_byte.md)
- [TO\_TIMESTAMP\_TZ](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/to_timestamp_tz.md)
- [UNISTR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/format-functions/unistr.md)
- [Math Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions.md)
- [BITAND](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/bitand.md)
- [COSH](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/cosh.md)
- [MOD](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/mod.md)
- [REMAINDER](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/remainder.md)
- [SINH](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/sinh.md)
- [TANH](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/math-functions/tanh.md)
- [Misc Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/misc-functions.md)
- [SYS\_GUID](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/misc-functions/sys_guid.md)
- [DUMP](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/misc-functions/dump.md)
- [Text Functions](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions.md)
- [INSTR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/instr.md)
- [LENGTH](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/length.md)
- [LPAD](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/lpad.md)
- [LTRIM](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/ltrim.md)
- [NLSSORT](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/nlssort.md)
- [REGEXP\_COUNT](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_count.md)
- [REGEXP\_INSTR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_instr.md)
- [REGEXP\_REPLACE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_replace.md)
- [REGEXP\_LIKE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_like.md)
- [REGEXP\_SUBSTR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/regexp_substr.md)
- [RPAD](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/rpad.md)
- [RTRIM](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/rtrim.md)
- [SUBSTR](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/sql-function/text-functions/substr.md)
- [Package](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package.md)
- [DBMS\_ALERT](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/dbms_alert.md)
- [DBMS\_OUTPUT](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/dbms_output.md)
- [DBMS\_PIPE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/dbms_pipe.md)
- [DBMS\_RANDOM](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/dbms_random.md)
- [DBMS\_SQL](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/dbms_sql.md)
- [UTL\_FILE](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/reference-guides/package/utl_file.md)
- [TroubleShooting](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/troubleshooting.md)
- [Common Issues](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/troubleshooting/common-issues.md): O2 Extension을 사용하면서 문제가 발생할 경우 수행할 수 있는 조치 방법을 설명한다.
- [Error codes](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/troubleshooting/error-code.md)
- [Large Data processing](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/troubleshooting/large-data-processing.md)
- [FAQ](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/troubleshooting/faq.md)
- [Release Note](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/release-note.md)
- [1.0](https://docs.tibero.com/tmaxopensql.en/tmax-o2-extensions/release-note/1.0.md)


---

# 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.en/tmax-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.