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?

Show your query. Oracle is case sensitive, are you getting a..z,A..Z for your results? — Thomas Jones-Low
– Thomas Jones-Low, Commented May 13, 2011 at 18:08
Query : select customer_name from customertable order by customer_name asc — harishtps
– harishtps, Commented May 13, 2011 at 18:14
show the actual results also - post them the pastebin as they will be large. — KevinDTimm
– KevinDTimm, Commented May 13, 2011 at 18:21

Lalchand · Accepted Answer · 2011-05-16 14:31:13Z

2

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

answered May 16, 2011 at 14:31

Lalchand

7,85727 gold badges69 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting in Oracle DB?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related