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: 4

Last Update: May 08, 2009 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

May 07, 2009 13:52:27

sateesh240

Member Since: September 2008 Contribution: 1

RE: 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?

Read character column into a PL/SQL table of numeric data type by converting to number pass the PL/SQL table to JavaScript as a parameter this is one way..

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank