Well this can be done one of two ways... The first is to use an ORDER BY statement when you retrieve the records from the oracle table or you can set the sorted property of the listbox to true...
Now, if you need help in retrieving records from an oracle database. Use your friends (yahoo, google, ask, answers, bing) and search for vb6 ado tutorial and see http://www.connectionstrings.com if you want to go with a DNS Less connection...
Private Sub software_prim()
strSQL = "select distinct Primavera from Master_final"
rs.Open strSQL, cn
If Not (rs.EOF And rs.BOF) Then
Do While Not rs.EOF
primavera = rs.Fields(0).Value
here cn is the connection
rs is the recordsouce
This has definitely worked for me
Hope it works for you to.