Pages

How to use PL/SQL TRIM?

TRIM('CharacterToBeTrimed', 'StringToBeTrimed') function cleans entered character from front and end of supplied string.

Example: Clean 'A' characters from front and of names of students

SELECT TRIM('A' FROM name) FROM students

No comments:

Post a Comment