Data Access Question:
Download Job Interview Questions and Answers PDF
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?
Answer:
select to_number(rollnumber) from tname order by rollnumber
Download Oracle Data Access Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain What are the different approaches used by Optimizer in choosing an execution plan ? | Explain When does a Transaction end? |