Sorting in Oracle DB?

Question

I am having 600 records in oracle DB which are to be sorted using their column in ascending and descending. While sorting we are getting an issue like the records are breaking into subsets and gets sorted(for eg) the first 250 records are sorted in the order A-Z and like that its splitting the records and gets sorted?

Iam not getting the sorted list for all the 600 records

Now i am getting output like below a b . . . z a .. .. .. z i want like a b c ..

z

Any suggestions?

Answer 1

It may be issue of regarding upper Case and Lower Case customer Name modify your query according to that.