User Profile

Collapse

Profile Sidebar

Collapse
sameera s
sameera s
Last Activity: Jun 6 '11, 12:43 PM
Joined: Nov 10 '10
Location: Bambalapitiya, Colombo, Sri Lanka
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • sameera s
    replied to How to use "rownum"
    in Oracle
    I tried it and it works
    Thanx Amith... :)
    See more | Go to post

      Leave a comment:

    • sameera s
      started a topic How to use "rownum"
      in Oracle

      How to use "rownum"

      Hi,
      I am doing a paging task. In order to do that I want to get data 10 by 10 raws from a table. How can I do this using "rownum" ?
      I tried in this way

      SELECT FROM (
      SELECT UPLOAD_DATE_TIM E,TYPE_OF_UPLOA D,PERFORMED_BY, STATUS,CLFILE_C OUNT,STCMAS_COU NT,CLSTMAS_COUN T,OPENTRN_COUNT ,START_TIME,FIN ISH_TIME,rownum rn
      FROM ONLINE_ACTION_H ISTORY where TYPE_OF_UPLOAD= 'OPERATIONAL' ORDER BY UPLOAD_DATE_TIM E...
      See more | Go to post
      No activity results to display
      Show More
      Working...