This guide is intended for database users who want a reference for the Structured Query Language (SQL), which is required to perform database tasks or develop application programs using Tibero ® (hereafter Tibero).
SQL provided by Tibero supports parts of the SQL-92 and SQL-99 standards, which were coestablished by the American National Standards Institute (ANSI) and the International Organization for Standardization/International Electrotechnical Commission (ISO/IEC).
This guide describes SQL statements needed to manage information in Tibero. The user must have knowledge of the following in order to understand this guide:
RDBMS
SQL
This guide does not contain all the information required to operate Tibero . For information related to installation, configuration, operation and management, refer to each relevant guide.
For more information about Tiberoinstallation and configuration, refer to "Tibero Installation Guide."
This guide consists of 9 chapters and 1 appendix.
Descriptions for each are as follows:
Chapter 1: Introduction to SQL
Describes basic concepts of SQL and SQL statements.
Chapter 2: SQL Elements
Describes the data types and schema objects provided byTibero.
Chapter 3: SQL Operations
Describes the SQL operators, general expressions, and conditional expressions provided by Tibero.
Chapter 4: Functions
Describes various built-in functions provided by Tibero.
Chapter 5: SQL Queries
Describes the SQL queries that can be used in Tibero.
Chapter 6: Materialized Views
Describes how to use materialized views provided by Tibero.
Chapter 7: Data Definition Language
Describes the data definition language provided by Tibero.
Chapter 8: Data Manipulation Language
Describes the data manipulation language provided by Tibero.
Chapter 9: Transaction and Session Management Language
Describes the transaction and session management language provided by Tibero.
Appendix A.: Reserved Words
Lists reserved words used in Tibero.
| Convention | Meaning |
|---|---|
| <AaBbCc123> | Filename of a program source code |
| <Ctrl>+C | Hold the Control key and press C |
| [Button] | Button or Menu name |
| Boldface | Emphasis |
| " " (double quotes) | Reference to chapters or sections in the manual, or to other related documentation |
| 'Input item' | Description for an input item on the screen |
Hyperlink | E-mail account, website, link to other chapters or sections |
| > | Progress order of menus |
| +---- | Files or directories exist below. |
| |---- | Files or directories do not exist below. |
Note | Reference or note |
| [Figure 1.1] | Figure name |
| [Table 1.1] | Table name |
AaBbCc123 | Command, execution result, or example code |
| { } | Required argument |
| [ ] | Optional argument |
| | | Selective argument |
| Document | Description |
|---|---|
Tibero Installation Guide | Describes the system requirements and specific methods for installation and uninstallation. |
Tibero tbCLI Guide | Describes the tbCLI (Call Level Interface) concepts, components and program structure, as well as data types, functions, and error messages needed to write tbCLI applications. |
Tibero Application Developer's Guide | Describes how to develop application programs by using application libraries. |
Tibero External Procedure Guide | Describes how to create and use external procedures. |
Tibero JDBC Developer's Guide | Describes how to develop application programs by using the JDBC functions provided in Tibero. |
Tibero tbESQL/C Guide | Describes how to create various database application programs in the C programming language. |
Tibero tbESQL/COBOL Guide | Describes how to create various database application programs in the COBOL programming language. |
Tibero tbPSM Guide | Introduces the concepts, syntax, and components of tbPSM (Procedure Storage Module). This guide also describes how to execute the control structure, complex type, sub programs, packages, and SQL statements required for creating a tbPSM program and to handle any errors. |
Tibero tbPSM Reference Guide | Introduces the tbPSM package, a storage procedure module. This guide also describes the prototypes, parameters, and examples of each procedure and function included in this package. |
Tibero Administrator's Guide | Describes how to manage Tibero in order to guarantee smooth operation. This guide also describes the various functions that support management. |
Tibero Utility Guide | Describes how to install, use, and configure the utilities that handle database related operations. |
Tibero TAS Guide | Describes how to manage Tibero files using Tibero Active Storage (TAS). |
Tibero Error Reference Guide | Describes troubleshooting methods for various errors that may occur while using Tibero. |
Tibero Reference Guide | Describes the initialization parameters, data dictionary, and static and dynamic views used by Tibero. |
Tibero Spatial Reference Guide | Describes the geometry type and spatial procedures and functions of Tibero and how to use them. |
Tibero TEXT Reference Guide | Describes how to create and use the text index provided by Tibero. |
Tibero Hadoop Connector Guide | Describes how to use the Tibero Hadoop Connector. |
TmaxData Co., Ltd.
45, Jeongjail-ro, Bundang-gu,
Seongnam-si, Gyeonggi-do, 13613
South Korea
Tel: +82-31-8018-1000
Fax: +82-31-8018-1115
Email: tibero@tmaxdata.com
Web (Korean): http://www.tmaxdata.com
TechNet: http://technet.tmaxsoft.com
TmaxSoft Inc.
230 West Monroe Street Suite 1950
Chicago, IL 60606
U.S.A
Tel: +1-312-525-8330
Fax: +1-312-525-8340
Email: info@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/us_en/home
TmaxSoft Japan Co., Ltd.
5F Sanko Bldg, 3-12-16 Mita, Minato-Ku, Tokyo, 108-0073
Japan
Tel: +81-3-5765-2550
Fax: +81-3-5765-2567
Email: info@tmaxsoft.co.jp
Web (Japanese): http://www.tmaxsoft.co.jp
Beijing TmaxSoft System Software Co., Ltd.
Room103, No.2 Huizhong Building, Seven Street Shangdi,
Haidian District, Beijing, 100085
P.R.China
Tel: +86-10-6298-8827
Email: info@tmaxsoft.com.cn
Web (Chinese): http://www.tmaxsoft.com/cn_en/home_cn_en
Tmax Brasil Sistemas E Serviços Ltda.
Av. Copacabana, 177, sala 32~35 Empresarial 18 do Forte
Alphaville Barueri, Sao Paulo, 06472-001
Brazil
Tel: +55-11-4191-3100
Fax: +55(11) 4191-3705 (extension#112)
Email: info.bra@tmaxsoft.com
Web (Portuguese): http://www.tmaxsoft.com/br_en/home_br_en
Tmax Rus L.L.C.
Leninsky prospekt, 113/1 (Park Place Moscow),
Office 318e, Moscow, 117198
Russia
Tel: +7(495)970-0135
Email: info.rus@tmaxsoft.com
Web (Russian): http://www.tmaxsoft.com/ru_ru/home_ru_ru
Tmax Singapore Pte. Ltd.
430 Lorong 6, Toa Payoh #10-02,
OrangeTee Building, 319402
Singapore
Tel: +65-6259-7223
Fax: +65-6258-7112
Email: info.sg@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/sg_en/home_sg_en
TmaxSoft UK Ltd.
215 Knyvett House, Watermans Business Park,
The Causeway, Staines TW18 3BA
United Kingdom
Tel: +44-1784-895005
Email: info.uk@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/gb_en/home_gb_en
TmaxSoft Canada, Inc.
2425 Matheson Blvd East, 8th floor,
Unit 824 Mississauga, ON, L4W 5K4
Canada
Tel: +1-905-361-2888
Email: info.canada@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/ca_en/home_ca_en
TmaxSoft Proprietary Limited
L32, 101 Miller Street, North Sydney 2060
Australia
Tel: +61-2-8019-7054
Email: info.aus@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/au_en/home_au_en
TmaxSoft Technologies Private Limited
Sobha Alexander Plaza, 3rd Floor,
16/2 Commissariat Road, Bangalore-560025
India
Tel: +91-7619-482-582
Email: info.india@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/in_en/home_in_en
TmaxSoft Co., Ltd. Turkey Liaison Office
Windowist Tower. Eski Buyukdere Cad. No:26,
Maslak 34467 Istanbul
Turkey
Tel: +90-212-214-7345
Email:info.tr@tmaxsoft.com
Web (English): http://www.tmaxsoft.com/tr_en/home_tr_en