#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    india
    Posts
    0
    Rep Power
    0
    Hi,
    we are using oracle database, Oracle Select statement is not supporting the LIMIT , Is there any other way to display records into pages.

    Thanks,
    saravanan.
  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    I'm sure that oracle has it's own implementation of LIMIT. You'll have to search through their docs....or you could always switch to MySQL..

    You'd probably have better luck asking in an Oracle forum..

    ---John Holmes...
  4. #3
  5. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15

    Give a try with ROWID or ROWNUM in Oracle

    ------------------
    SR -
    webshiju.com
    www.jobxyz.com-IT Career Portal
    ezipindia.com--WebStudio


    "The fear of the LORD is the beginning of knowledge..."

Similar Threads

  1. Dynamic display of unknown # of db records...?
    By mikeyguitar in forum Flash Help
    Replies: 0
    Last Post: February 10th, 2004, 10:14 PM
  2. how to display all the records in the database(mySQL)
    By icepricessa in forum PHP Development
    Replies: 2
    Last Post: February 8th, 2004, 06:59 PM
  3. Replies: 7
    Last Post: January 14th, 2004, 08:53 PM
  4. Replies: 7
    Last Post: January 13th, 2004, 04:19 PM
  5. Limit the number of results pages
    By capt.ace in forum ASP Programming
    Replies: 2
    Last Post: January 12th, 2004, 01:16 PM

IMN logo majestic logo threadwatch logo seochat tools logo