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;