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!

UPPER vs LOWER

user457357Apr 11 2007 — edited Apr 11 2007
I read on a website yesterday that when developing LOWER()should be used instead of UPPER() as lower has a performance gain over upper when used in sql syntax. Does anyone know if this is true and if so why. Thanks for the help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2007
Added on Apr 11 2007
20 comments
4,459 views