Interviewer And Interviewee Guide

Data Access Interview Question:

Explain 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?

Submitted by: Administrator

select to_number(rollnumber) from tname order by rollnumber
Submitted by: Administrator