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
      • 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;
        • 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;