Answer Detail: 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?

GeekInterview.com > Interview Questions > Oracle > Data Access

Print |

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

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

May 05, 2009 13:52:27	#4
sateesh240	Member Since: September 2008 Total Comments: 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..

Back To Question