Oracle PL/SQL - Trim CHAR and VARCHAR2 Value

  1. HOME
  2. Oracle PL/SQL
  3. PL SQL Data Type
  4. CHAR and VARCHAR2 Variables Size

Introduction

To strip trailing blanks from a character value before assigning it to a variable or inserting it into a column, use the RTRIM function.

Demo

SQL>
SQL> DROP TABLE t;

Table dropped.-- from   w w  w. j  ava 2 s.co m

SQL> CREATE TABLE t (c CHAR(3 CHAR));
SQL>
SQL> DECLARE
  2    c VARCHAR2(3 CHAR);
  3  BEGIN
  4    c := RTRIM('abc  ');
  5    INSERT INTO t(c) VALUES(RTRIM('abc  '));
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

C
---
abc

1 row selected.

SQL>

Related Topic