Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Rownum? (Score:2, Informative)

    SELECT * FROM myTable WHERE ROWNUM < 50;

    Isn't that equivalent?

    /claes

    • Yes, but what do you do for page two, when you want 50 < ROWNUM < 100?

      <g>

      --
      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
      • exactly.

        This is much easier in MySQL.

        We will probably move most this kind of SQL (large blocks) into Phrasebook classes, just doing an execute_query('queryname',%args) or something.

        If rownum was computed after the order by then it would be very useful - shame it isn't.

        btw - we have about 8 O Reilly PL/SQL and Oracle books scattered around the desk of the dev team - I don't have time to read them tho, thats why have the TOAD jockies to keep the scary bad bits of oracle hidden in nice procedures and o

        --

        @JAPH = qw(Hacker Perl Another Just);
        print reverse @JAPH;
        • we have about 8 O Reilly PL/SQL and Oracle books scattered around the desk of the dev team

          Which ones have you got? :D (I'm going on 14 physical books now plus the CD bookshelf, with two more on order.)

          This place is starting to look like use PL/SQL; . Which isn't a bad thing, I suppose. ;)

          --
          J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
          • erm.. a load with ants and millipedes, A Practical Oracle 8i, the rest are buried under peoples workings out and schema diagrams.

            I just have J P Harringtons, SQL Clearly explained and Halsall;s data Comms, Computer Networks, and open systems on my desk as well as the usual Perl books.

            --

            @JAPH = qw(Hacker Perl Another Just);
            print reverse @JAPH;
      • select
           rownum myrownum
           ,stuff
        from
           mytable
        where
           myrownum>50
           and myrownum<50
        • That's great, but it doesn't work.

          --
          J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers
          • select myrownum,stuff from(select (rownum) myrownum,stuff from mytable) where myrownum>50 and myrownum100 you're right, but this does.. not sure why it doesn't allow you to alias the rownum in the outer query
            • the only reason I think the rownum concept has merit, is if you want to have a query on a table that is ordered by something other than the primary key - and you want to find a particular value, and view the rows around it.

              if there is an easy way to do that using limits and offsets let me know.. I'm trying to make a dictionary page that finds a word and prints nearby words (in mysql) - while reading up on it I found the oracle rownum stuff and decided it would be easier with that.

              I guess I could do a