Data Access - There is a field of type character in the table, but we are storing numeric values like (Roll number

GeekInterview.com > Interview Questions > Oracle > Data Access

Go To First | Previous Question | Next Question

Data Access | Question 18 of 27

There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers.How?

by creating a function for sorting in the front end(guessing, i am not sure. plz answer it)

Total Answers and Comments: 3

Last Update: December 04, 2006 Asked by: sanyogkesar

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 07, 2006 03:43:44

e.gomathi

RE: There is a field of type character in the table, b...

select to_number() from order by ;

Is this answer useful? Yes | No

February 07, 2006 04:32:21

e.gomathi

RE: There is a field of type character in the table, b...

select to_number(rollnumber) from tname order by rollnumber

Is this answer useful? Yes | No

December 04, 2006 12:40:12

rampratap409

Member Since: September 2006 Contribution: 111

RE: There is a field of type character in the table, b...

use:

select to_number(rollnumber) from tname order by to_number(rollnumber);

select rollnumber from tname order by to_number(rollnumber);

convert the value to integer in java

Is this answer useful? Yes | No

Go To Top