Mega Code Archive
Categories
/
Oracle PLSQL
/
Char Functions
Simple demo for TRIM function
SQL> SQL> --For example, the following query removes the character "S" from a string: SQL> SQL> SELECT TRIM('S' FROM 'STEVENS') AS TRIM FROM Dual; TRIM ----- TEVEN SQL>