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!

Trimming double byte space in Oracle

Vikas KumarAug 27 2010 — edited Aug 30 2010

Dear All,

DB Version: Oracle 10g
Client : Oracle SQL Developer

How can we TRIM double byte space in Oracle without first converting it into single byte and then using TRIM function.

Sample data is :
トヨタカロ－ラナンカイ　（カ　

I want to TRIM trailing double byte space.

Regards,
Vikas Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2010

Added on Aug 27 2010

6 comments

2,176 views