• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2599
  • Last Modified:

oracle trim and upper functions

Hi,

have you ever caught oracle truncating string when using these function together?

upper(trim(:P21_SERV_CITY))
0
davidlars99
Asked:
davidlars99
  • 2
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no.
0
 
davidlars99Author Commented:
ok thanks!
0
 
davidlars99Author Commented:
are you 100% sure ?!
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes.
now, if you think you have a sample to reproduce the problem, please post it here, I guess we will find the "problem"
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now