Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to trim spaces

user11221081Sep 1 2009 — edited Sep 1 2009
Hi Guys

i have a table having a column dob which stores the date of birth of client like 03081983

now sometimes user insert spaces in start or end or middle like

03081983
03 08 1983
03081983__

these spaces are shown in my database with a dark straight line looking like a concatenated operator.

so i want to remove or trim this please tell me the query to trim .

Rgds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2009
Added on Sep 1 2009
13 comments
2,995 views