Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Posts
    13

    Unanswered: Number of rows selected

    Hi there,

    Does anyone know why Oracle SQL+ does not return the number of rows selected after a select query is performed? The funny thing is that I have 4 very similar SQL select statements in one text file and all return the number of rows selected except for the last one. Anyone familiar with this kind of behavior? I'm pretty sure the returned result for the last query is correct, but it bothers me not to know why the number of rows is not shown.

    Thanks for your input!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    The answer can be found by RTFM on SQL*Plus & the keyword FEEDBACK.
    I suspect the last query only returns a small number of rows.
    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
    Feb 2006
    Posts
    13
    Thanks for the pointer to the feedback keyword. In fact the result was less than 6, which seems to be the default value. How did they come up with that?!

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    It fits on the screen and is small enough to look at and say "HEY.... There are 5 rows returned", quicker then looking for a feedback line.
    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
  •