Syntax
RTRIM(str)
Purpose
Removes trailing spaces from the string str.
Examples
obclient> SELECT RTRIM(' obclient ') AS rtrim;
+--------------+
| rtrim |
+--------------+
| obclient |
+--------------+
1 row in set
RTRIM
Share
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
Meet OceanBase AI Database, the unified database for operational data, real-time analytics, and AI. Explore ->
All Products
OceanBase Database
SQL - V4.6.0
Download PDF
What's New Overview Architecture Overview of Oracle compatibility SQL data types Built-in functions System views Compatibility with MySQLLimitations Quick start with OceanBase Database Community Edition Before you begin Basic SQL operations (MySQL mode) Basic SQL operations (Oracle mode) Build a Python application Build a Java application Build a C application Build a Go application Create a Java sample application Create a C application Try out operational OLAP Try out parallel import and data compression Try out the multi-tenant feature Overview HA deployment solutions for OceanBase clusters Deployment process Deploy OceanBase Database Java SDK Clear an OceanBase cluster Recommended configurations Overview Upgrade an arbitration service Upgrade an OceanBase cluster Check the status after the upgrade Upgrade OceanBase Database with obd Overview Use OMS to migrate data from a MySQL database to a MySQL tenant of OceanBase Database Use mydumper and myloader to migrate data from a MySQL database to OceanBase Database Use DBCAT to migrate schemas from a MySQL database to OceanBase Database Use DataX to migrate table data from a MySQL database to OceanBase Database Use CloudCanal to migrate data from a MySQL database to OceanBase Database Use Canal to synchronize data from a MySQL database to OceanBase Database Use Flink CDC to synchronize data from a MySQL database to OceanBase Database Use ChunJun to migrate data from a MySQL database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a MySQL database Use OMS to migrate incremental data from an Oracle tenant of OceanBase Database to a MySQL database Use DBCAT to migrate schemas from OceanBase Database to a MySQL database Use DataX to migrate table data from OceanBase Database to a MySQL database Use Canal to synchronize data from OceanBase Database to a MySQL database Use CloudCanal to migrate data from OceanBase Database to a MySQL database Use Flink CDC to migrate data from OceanBase Database to a MySQL database Use ChunJun to migrate data from OceanBase Database to a MySQL database Use OMS to migrate data from an Oracle database to a MySQL tenant of OceanBase Database Use OMS to migrate data from an Oracle database to an Oracle tenant of OceanBase Database Use DBCAT to migrate schemas from an Oracle database to OceanBase Database Use DataX to migrate table data from an Oracle database to OceanBase Database Use OMS to migrate data from an Oracle tenant of OceanBase Database to an Oracle database Use DBCAT to migrate schemas from OceanBase Database to an Oracle database Use DataX to migrate table data from OceanBase Database to an Oracle database Use OMS to migrate data from a DB2 LUW database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a DB2 LUW database to an Oracle tenant of OceanBase Database Use DBCAT to migrate table schemas from a DB2 LUW database to OceanBase Database Use OMS to migrate data from a MySQL tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from an Oracle tenant of OceanBase Database to a DB2 LUW database Use OMS to migrate data from a TiDB database to a MySQL tenant of OceanBase Database Use OMS to migrate data from a PostgreSQL database to a MySQL tenant of OceanBase Database Use DataX to migrate CSV files to OceanBase Database Import data by using the LOAD DATA statement Import data from SQL files to OceanBase Database Use OMS to migrate data from an OceanBase tenant to another of the same type Use OMS to migrate data from an OceanBase tenant to another of the same type in active-active disaster recovery scenarios Use obloader & obdumper to migrate data between MySQL tenants in OceanBase Database Use obloader & obdumper to migrate data from a MySQL tenant to an Oracle tenant in OceanBase Database Use obloader & obdumper to migrate data between Oracle tenants in OceanBase Database Use obloader & obdumper to migrate data from an Oracle tenant to a MySQL tenant in OceanBase Database Migrate data between tables Migrate resource units Export data using the OUTFILE statement Overview of direct load Log in to an OceanBase tenant OverviewCluster parameters Tenant introduction Tenant capacity Tenant types User tenant introduction Tenant system variables Create a log stream Modify a log stream Replicas Traffic distribution Data distribution Overview Transfer Partition Cancel a partition transfer task Cancel a Balance Job GTS standalone application scenario High availability overview Flashback queries OverviewOverview of physical backup and restore Experience physical backup and restore with simplified deployment