Hello sir, Let me explain what my problem is with an example that best suits my current problem. For example, I have a jsp page with field "Level".That jsp page contains code(for example, select level from tname order by 2 asc) for that field "Level".If we assume that the field Level has a list box with values "One, Two and so on". Now on the database side I would like to add new value into that Level field "Three".After inserting new value into that field, I commit the change on the database side(sql>commit). When I refresh the jsp page, I could see the new value in the existing list box values. Coming to the current problem, i sort a list of values through a procedure/function.when I execute format_numeric(function) and sort function, i could get the desired output. But when i refresh that particular jsp, i could not find the values in the sorted order.Could you please let me know what i need to do when i execute the format_numeric function + sort statement. Eagerly Waiting for reply!.