Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2009
    Posts
    13

    Unanswered: Count results in loop

    HI

    I have a loop which loops through records in a table
    How can I count the results from the loop?
    I need to display this.

    thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2009
    Posts
    13
    Thanks for the reply. I figured that out just before you posted.
    However I need to display that in
    utl_file.put_line(v_file, COUNTROWS);
    This works fine but when i want to add some text to say Row Count it keeps falling over, how can I add some text to the above line?
    thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    > i want to add some text to say Row Count it keeps falling over, how can I add some text to the above line?

    Why do you expect anyone to debug code we can not see?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2009
    Posts
    13
    OK
    Ive done it
    I needed to declare the varchar value at the begining of the statemment
    thanks

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Ive done it
    Your mother should be proud of you now.
    You can take off the remainder of the day.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Aug 2009
    Posts
    13
    Thanks.
    Your mother was proud of me too....

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    utl_file.put_line(v_file, 'this is my string and this is my count '||to_char(COUNTROWS));
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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