Use the LIMIT clause in queries|V4.0.0|OceanBase Database| docs|Distributed Database

OceanBase Database

V4.0.0Enterprise Edition

Overview
- Overview
- System architecture
- Compatibility with MySQL
- Compatibility with Oracle
  - Overview
  - SQL data types
  - Built-in functions
  - System views
- Limits
Get Started
- Quick start with OceanBase Database
- Hands on for OceanBase SQL
  - Usage notes
  - Basic SQL operations (MySQL mode)
  - Basic SQL operations (Oracle mode)
- Build applications (MySQL Mode)
  - Connect Python applications to OceanBase Database
  - Connect Java applications to OceanBase Database
  - Connect C applications to OceanBase Database
- Build applications(Oracle Mode)
  - Connect Python applications to OceanBase Database
  - Connect Java applications to OceanBase Database
  - Connect C applications to OceanBase Database
- Experience OceanBase advanced features
  - Experience scalable OLTP
    - Run the TPC-C benchmark in OceanBase Database
    - Experience the hot row update capability of OceanBase Database
  - Experience operational OLAP
  - Experience parallel import and data compression
  - Experience the multitenancy feature
Develop
- Develop (MySQL Mode)
  - Connect to Oceanbase Database with client
    - Overview
    - Connect to an OceanBase Database tenant by using a MySQL client
    - Connect to an OceanBase Database tenant by using OBClient
    - Connect to OceanBase Database by using ODC
    - Java application
      - OceanBase Connector/J
      - Java APIs
      - Connect Java applications to OceanBase Database
    - C application
      - OceanBase Connector/C
      - C API functions
      - Connect C applications to OceanBase Database
    - Python applications
    - SpringBoot connection example
    - SpringBatch connection example
    - Example of Database connection pool configuration
      - Overview of database connection pool configuration
      - Example of configuring a Tomcat connection pool
      - Example of configuring a C3P0 connection pool
      - Example of configuring a Proxool connection pool
      - Example of configuring a HiKariCP connection pool
      - Example of configuring a DBCP connection pool
      - CommonPool configuration example
      - Example of configuring a JDBC connection pool
    - SpringJDBC connection example
    - SpringJPA connection example
    - Hibernate connection example
    - MyBatis connection example
  - Create and manage database objects
    - About DDL statements
    - View the currently connected database
    - Change the password of a user
    - Data type
      - General data types
      - Unsupported data types
    - Create and manage tables
      - About tables
      - Create a table
      - About auto-increment columns
      - About types of column constraints
      - About table structure modification
      - About table clearing
      - About table dropping
      - Flash back a dropped table
      - About table privileges
    - Create and manage partition tables
      - About partitioned tables
      - Create a partitioned table
      - Manage a partitioned table
      - Create a subpartitioned table
      - Manage a subpartitioned table
      - Partition routing
      - Indexes on partitioned tables
      - Suggestions on using partitioned tables
    - Create and manage indexes
      - About indexes
      - Create an index
      - Drop an index
    - Create and manage views
      - About views
      - Create a view
      - Modify a view
      - Delete a view
    - Create and manage sequences
      - About sequences
      - Create a sequence
      - Modify a sequence
      - Delete a sequence
    - Create and manage triggers
      - About triggers
      - Create a trigger
      - Delete a trigger
  - Query
    - About queries
    - Single-table queries
    - Conditional queries
    - ORDER BY queries
    - GROUP BY queries
    - Use the LIMIT clause in queries
    - Query data from multiple tables
      - About multi-table join queries
      - INNER JOIN queries
      - OUTER JOIN queries
      - Subqueries
    - Use operators and functions in a query
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string connectors in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use the CASE conditional operator in queries
      - Use the SELECT FOR UPDATE statement to lock query results
    - Execution plan
      - View an execution plan
      - Understand an execution plan
    - Use SQL hints in queries
    - Variables of query timeout
  - DML statements and transactions
    - DML statement
      - About DML statements
      - About the INSERT statement
      - UPDATE statements
      - About the DELETE statement
      - About the REPLACE INTO statement
    - Transactions
      - About transaction control statements
      - Start a transaction
      - Transaction savepoints
      - Commit a transaction
      - Roll back a transaction
      - About transaction timeout
  - Common errors and solutions
    - About error codes
    - Database connection error
    - About timeout
      - Idle session timeout
      - Transaction timeout errors
    - About user
      - Locked user
      - Incorrect user password
    - About table
      - Table already exists
      - Table does not exist
      - Invalid use of NULL value
    - About constraint
      - Unique key conflict
      - Foreign key conflict
    - About SQL commands
      - Data truncation
- Develop (Oracle Mode)
  - Connect to Oceanbase Database with client
    - Overview
    - Connect to an OceanBase tenant by using an Oracle client
    - Connect to an OceanBase Database tenant by using OBClient
    - Connect to OceanBase Database by using ODC
  - Application development
    - Java application
      - OceanBase Connector/J
      - Java APIs
      - Connect Java applications to OceanBase Database
    - Python application
      - OceanBase Connector/J in Python
      - Python APIs
      - Connect Python applications to OceanBase Database
    - 300.c-application-1
      - OceanBase Connector/C
      - OBCI APIs
      - Connect C applications to OceanBase Database
  - Create and manage database objects
    - About DDL statements
    - View the currently connected database
    - Change the password of a user
    - Data type
      - General data types
      - Unsupported data types
    - Create and manage tables
      - About tables
      - Create a table
      - Define an auto-increment column by using the SEQUENCE keyword
      - About types of column constraints
      - About table structure modification
      - About table clearing
      - About table dropping
      - Flash back a dropped table
      - About table privileges
    - Create and manage partition tables
      - About partitioned tables
      - Create a partitioned table
      - Manage a partitioned table
      - Create a subpartitioned table
      - Manage a subpartitioned table
      - Partition routing
      - Indexes on partitioned tables
      - Suggestions on using partitioned tables
    - Create and manage indexes
      - Drop an index
      - About indexes
      - Create an index
    - Create and manage views
      - About views
      - Create a view
      - Modify a view
      - Drop a view
    - Create and manage sequences
      - About sequences
      - Create a sequence
      - Modify a sequence
      - Delete a sequence
    - Create and manage synonyms
      - About synonyms
      - Create a synonym
      - Delete a synonym
    - Create and manage triggers
      - About triggers
      - Create a trigger
      - Modify a trigger
      - Delete a trigger
      - Enable or disable a trigger
  - Query
    - About queries
    - Single-table queries
    - Conditional queries
    - ORDER BY queries
    - GROUP BY queries
    - Use Row_Limiting_Clause in queries
    - Query data from multiple tables
      - About multi-table join queries
      - INNER JOIN queries
      - OUTER JOIN queries
      - Subqueries
    - Use operators and functions in a query
      - Use arithmetic operators in queries
      - Use numerical functions in queries
      - Use string concatenation operators in queries
      - Use string functions in queries
      - Use datetime functions in queries
      - Use type conversion functions in queries
      - Use aggregate functions in queries
      - Use NULL-related functions in queries
      - Use CASE functions in queries
      - Use the SELECT FOR UPDATE statement to lock query results
    - Execution plan
      - View execution plans of queries
      - Understand an execution plan
    - Use SQL hints in queries
    - About query timeout variables
  - DML statements and transactions
    - DML statement
      - About DML statements
      - About the INSERT statement
      - UPDATE statements
      - About the MERGE statement
      - About the DELETE statement
    - Transactions
      - About transaction control statements
      - Start a transaction
      - Transaction savepoints
      - Commit a transaction
      - Roll back a transaction
      - About transaction timeout
  - Common errors and solutions
    - Overview
    - Database connection error
    - About timeout
      - Idle session timeout
      - Transaction timeout errors
    - About user
      - Locked user
      - Incorrect user password
    - About object
      - Object already exists
      - Object does not exist
    - About constraint
      - Unique key conflict
      - Foreign key conflict
    - About sql
      - Data type inconsistency
Deploy
- Overview
- Deployment procedure
- Preparations before deployment
  - Prepare servers
  - Configure servers
  - Prepare installation packages
- HA solution for OceanBase clusters
- Deploy through the CLI
  - Configure the deployment environment
    - Install oat-cli
    - Use oat-cli to configure the deployment environment
    - Configure the clock source
    - Upload installation packages
    - Configure host information
    - Check the environment before deployment
  - Deploy OCP
    - Deployment description
    - Generate a configuration file
    - Start deployment
    - Check after deployment
  - Deploy the OceanBase cluster
    - Deploy a single-replica OceanBase cluster
    - Deploy a three-replica OceanBase cluster
  - Deploy OBProxy
    - Deploy OBProxy through the CLI
  - Create an OceanBase tenant
    - View resources available for a business tenant
    - Create a tenant
    - Verify after deployment
  - Deploy OMS
    - Deployment description
    - Modify the configuration file
    - Start deployment
    - Check after deployment
  - Deploy ODC
    - Deployment description
    - Modify the configuration file
    - Start deployment
    - Check after deployment
Migrate
- Overview
- Migrate data by using SQL scripts
- Migrate data by using MySQLDump
- Migrate data by using DataX
- Migrate data by using OUTFILE statements

Download PDF

Company

About OceanBase Contact Us

Product

OceanBase Dedicated OceanBase Database Quick Start Download Pricing

Resources

Docs Blog White Paper Trust Center