PL SQL Data Types Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. PL SQL Data Types
  4. Trim a text string in PLSQL
SQL>
SQL> DECLARE
  2     hollywood VARCHAR2(100) := 'AAAAAAAAVVVVVVV';
  3  BEGIN
  4     DBMS_OUTPUT.PUT_LINE (RTRIM (hollywood, 'V'));
  5  END;
  6  /
AAAAAAAA
PL/SQL procedure successfully completed.
SQL>