retrieve records in disperse way

[krishnareddy]

i am having a records like abcde, i know the way of executing them in ascending/descending,but how to retrieve the records in b,d,a,c like. with out using unions

please help me out in this issue

[davey23uk]

what are you ordering on though, your post is just random - or do you want a random order?

[ahmadbilal]

If there Are No Resrtication in Sorting Order Then Try This In Where Condation

"where dbms_utility.get_hash_value(dump(rowid),0,100)<10;"