YouOracle
Simple Oracle
Pages
Home
About
Showing posts with label
PL/SQL TRIM
.
Show all posts
Showing posts with label
PL/SQL TRIM
.
Show all posts
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
Older Posts
Home
Subscribe to:
Comments (Atom)