Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    22

    Exclamation Unanswered: Examples of count statements help...

    Could someone post examples of pl sql count statements in loops? I need a count statement in my homework assignment and I can't figure it out....???

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    If this is the same problem as the prior two posts, you don't need to count.

    Code:
    DECLARE
      i  NUMBER(8);
      CURSOR my_cursor... 
    BEGIN
      FOR v_row IN my_cursor LOOP
        IF v_row.foo > 2 THEN 
          i := i + 1;
        END IF;
      END LOOP;
    END;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •