Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Case Unsensitive VARCHAR2 ordering
How can I make Oracle ignore differences between upper case and lower case characters (VARCHAR02) while ordering ?
Example
SELECT name FROM peoples ORDER BY name;
should return :
Name
Thanks!
Luca Minudel software designer Italy Conegliano (TV) voice & fax +39 (0)438 412280 e-mail luca.minudel_at_nline.it WWW (italian language used)http://www.geocities.com/SiliconValley/Vista/4041