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: Administratorselect to_number(rollnumber) from tname order by rollnumber
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Access Job Interview Questions And Answers
Top Data Access Questions
| ☺ | Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach? |
| ☺ | Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command? |
| ☺ | What is COST-based approach to optimization? |
| ☺ | Explain What does ROLLBACK do? |
| ☺ | Explain What is Execution Plan? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
