YouOracle
Simple Oracle
Pages
Home
About
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment