Table of Contents

• Preface
• About This Manual
• 1. Introduction to Altibase SQL
• Overview of Altibase SQL
• Types of SQL Statements
• 2. Altibase SQL Basics
• Comments
• Altibase Objects
• HINT
• Hint List
• 3. Data Definition Language
• ALTER DATABASE
• ALTER DATABASE LINKER
• ALTER INDEX
• ALTER JOB
• ALTER QUEUE
• ALTER REPLICATION
• ALTER SEQUENCE
• ALTER TABLE
• ALTER TABLESPACE
• ALTER TRIGGER
• ALTER USER
• ALTER VIEW
• ALTER MATERIALIZED VIEW
• COMMENT
• CONJOIN TABLE
• CREATE DATABASE
• CREATE DATABASE LINK
• CREATE DIRECTORY
• CREATE INDEX
• CREATE JOB
• CREATE QUEUE
• CREATE REPLICATION
• CREATE ROLE
• CREATE SEQUENCE
• CREATE SYNONYM
• CREATE TABLE
• CREATE DISK TABLESPACE
• CREATE MEMORY TABLESPACE
• CREATE VOLATILE TABLESPACE
• CREATE TEMPORARY TABLESPACE
• CREATE TRIGGER
• CREATE USER
• CREATE VIEW
• CREATE MATERIALIZED VIEW
• DISJOIN TABLE
• DROP DATABASE
• DROP DATABASE LINK
• DROP DIRECTORY
• DROP INDEX
• DROP JOB
• DROP QUEUE
• DROP REPLICATION
• DROP ROLE
• DROP SEQUENCE
• DROP SYNONYM
• DROP TABLE
• DROP TABLESPACE
• DROP TRIGGER
• DROP USER
• DROP VIEW
• DROP MATERIALIZED VIEW
• FLASHBACK TABLE
• GRANT
• PURGE TABLE
• RENAME TABLE
• REVOKE
• TRUNCATE TABLE
• 4. Data Manipulation Language
• DELETE
• INSERT
• LOCK TABLE
• SELECT
• UPDATE
• MOVE
• MERGE
• ENQUEUE
• DEQUEUE
• 5. Data Control Language
• ALTER REPLICATION
• ALTER SESSION
• ALTER SYSTEM
• AUDIT
• COMMIT
• DELAUDIT
• NOAUDIT
• SAVEPOINT
• ROLLBACK
• SET TRANSACTION
• 6. Set Operators
• UNION
• UNION ALL
• INTERSECT
• MINUS
• Order of Operations
• 7. SQL Functions
• Introduction to SQL Functions
• Aggregate Functions
• Window (Analytic) Functions
• Numeric Functions
• Character Functions
• Datetime Functions
• Conversion Functions
• Encryption Functions
• Other Functions
• 8. Arithmetic Operators
• Arithmetic Operators
• Unary Operator
• Binary Operators
• Concatenation Operator
• CAST Operator
• 9. SQL Conditions
• SQL Conditions Overview
• Logical Condition
• Comparison Conditions
• Other Conditions
• Appendix A. Regular Expressions
• Regular Expression Support