-
I would like to sort the data in a table based on alphabetical order of a name column. I have tried asc but instead of showing the data (name column) in alphabetical order it shows it based on the length of the name. The variable type is varchar2 for the column. I am sure this is a very basic issue. please help
Marc
-
I think from reading your message it should work....
try this.. and let me know if it worked like it should (i.e. files listed in alphabetical order by name)
select name, file#, ts# from v$datafile order by name asc;
-
mullrich24,
select name from mytable order by upper(name) asc
-
the 'upper' did it.
thanks,
I love it, regards
Marc
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|