use Perl

• Rownum? (Score:2, Informative)

  by claes (1758)

  SELECT * FROM myTable WHERE ROWNUM < 50;

  Isn't that equivalent?

  /claes
  • Re:Rownum? (Score:2)

    by jdavidb (1361)

    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
    • Re:Rownum? (Score:1)

      by TeeJay (2309) on 2003.02.13 18:17 (#17010) Homepage Journal

      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 objects and then wrapped in nice layers of perl. (although some of it would be better wrapped in concrete and dumped in the north sea).

      --
      
      @JAPH = qw(Hacker Perl Another Just);
      print reverse @JAPH;

      Reply to This

      Parent

      • Re:Rownum? (Score:2)

        by jdavidb (1361)

        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
        • Re:Rownum? (Score:1)

          by TeeJay (2309)

          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;