Case Unsensitive VARCHAR2 ordering

From: Luca Minudel <luca.minudel_at_nline.it>
Date: 1998/03/21
Message-ID: <01bd5502$3b835440$069e15c2@w95luca>#1/1

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

---

Luca1
LUCA2
lUca3

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

---

Received on Sat Mar 21 1998 - 00:00:00 CST