Re: window solution :-)

jazzz_ wrote:

> does anyone know how to get lower case usernames using sqlplus?

select lower(username) from all_users

I hope next question won't be how to alphabetically sort usernames... :)

Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)

"Torna il re. Prosegue l'attesa per fante e cavallo."
(da "Umanità Nova" n. 14 del 21 aprile 2002)