Regular Expressions Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Regular Expressions Functions
  4. Convert a name in the form first middle last into the last, middle first format
SQL>
SQL> SELECT REGEXP_REPLACE('Hubert Horatio Hornblower',
  2      '(.*) (.*) (.*)',
  3      '\3, \2 \1') "Reformatted Name"
  4  FROM dual ;
Reformatted Name
--------------------------
Hornblower, Horatio Hubert
SQL>