Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I am getting extra spaces in one field

Sangeeta PandeyAug 30 2021

Hello Experts,
I am getting extra spaces in one field (diag_code_type) at table diagnosis_d.
Table is like below.
image.pngIn source actual length of value is 17, however length of column become 30 in target diagnosis_d.
image.pngI tried to trim the column in source before populating the value to target table, however it did not work.
I guess space is getting added once value is populated.
What would be best approach to fix this?

Thanks,

This post has been answered by Jan Gorkow on Aug 30 2021
Jump to Answer
Comments
Post Details
Added on Aug 30 2021
6 comments
1,463 views