0

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad:

4
Contributors
3
Replies
4
Views
11 Years
Discussion Span
Last Post by arunaponnuraj
0

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad:

this is simple u have to make a onject of Resultset and then access the value retrieved by object.next();......might this will work

1

hi guys,
i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad:

To get the results in the correct order you can add an ORDER BY clause to your query. DESC stands for descending which will start with the hightest values first.

SELECT t.col_1, t.col_2, t.date_col
FROM some_table t
WHERE t.col_1 = ‘something’
ORDER BY t.date_col DESC

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.