Sorting in drop down list

I am working in Oracle Forms 10g and I am successful in populating the item list with values queries from a database.

i.e. select column1, column2 from tablename order by 1

My question is the following: Is it possible to commingle the sorted values. In other words, I have upper and lower case values in tablename and when they're ordered, the upper cases appear first and then the lower case. Is there anyway to not have oracle do that and instead sort them alphabetically regardless of case?

---

[Quoted] Secondly, is there a way in Oracle Forms 10g to implement in a
list-item an auto detect/complete feature? Right now, the drop down
lists behave in such a way that it does not highlight the most closely
matched value. It only highlights when you type in a word or select a
word that is already in the list. I want it to be able to auto
detect/complete and highlight possible matches for queries you have
made...I hope that makes sense.

Any help with the first issue would be appreciated. Thanks.