simple question about sql*plus

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • khangu
    #1

    simple question about sql*plus

    Hello!
    i am a newbie in oracle database. I have some question about SQL*PLUS

    Currently, i have some table in an oracle database. When i open
    SQL*PLUS and type my query: "select * from employee". It display for
    me all the record in the database and then it also display how many
    record has been selected.
    but if i try to do this: "select * from customer" or select any table
    it still display all the record in that table but it didn't display
    the summary of how many record it has selected in that table. i would
    like to enable that feature in all the table that i have. i wonder if
    anyone have suggestion for me. thank you ahead for all the response
    and suggestion. it helps me a lot. so please send me your suggestion.
    all suggestion is appreciated. thank you very much. bye now.
    Tags: None
    • mcstock
      #2
      Re: simple question about sql*plus

      you want to use the 'SET FEEDBACK xx' SQL*Plus command ... the default is 6
      or more rows

      you can type this command at the SQLprompt each time you log in, or put it
      in a 'login.sql' file (you can set up a local or global login.sql -- check
      out the docs at http://tahiti.oracle.com

      "khangu" <nguyenk1@seatt leu.eduwrote in message
      news:b62dcb89.0 310241231.7931e 8d6@posting.goo gle.com...
      Hello!
      i am a newbie in oracle database. I have some question about SQL*PLUS
      >
      Currently, i have some table in an oracle database. When i open
      SQL*PLUS and type my query: "select * from employee". It display for
      me all the record in the database and then it also display how many
      record has been selected.
      but if i try to do this: "select * from customer" or select any table
      it still display all the record in that table but it didn't display
      the summary of how many record it has selected in that table. i would
      like to enable that feature in all the table that i have. i wonder if
      anyone have suggestion for me. thank you ahead for all the response
      and suggestion. it helps me a lot. so please send me your suggestion.
      all suggestion is appreciated. thank you very much. bye now.


        Comment

        • Paul
          #3
          Re: simple question about sql*plus

          set feed on

          set feed 6
          will only show the resulting number if 6 or more rows are generated by your
          query

          set feed off
          never tells you how many rows are returned


          "khangu" <nguyenk1@seatt leu.eduwrote in message
          news:b62dcb89.0 310241231.7931e 8d6@posting.goo gle.com...
          Hello!
          i am a newbie in oracle database. I have some question about SQL*PLUS
          >
          Currently, i have some table in an oracle database. When i open
          SQL*PLUS and type my query: "select * from employee". It display for
          me all the record in the database and then it also display how many
          record has been selected.
          but if i try to do this: "select * from customer" or select any table
          it still display all the record in that table but it didn't display
          the summary of how many record it has selected in that table. i would
          like to enable that feature in all the table that i have. i wonder if
          anyone have suggestion for me. thank you ahead for all the response
          and suggestion. it helps me a lot. so please send me your suggestion.
          all suggestion is appreciated. thank you very much. bye now.

            Comment

            • gadhiraju
              #4
              Re: simple question about sql*plus

              nguyenk1@seattl eu.edu (khangu) wrote in message news:<b62dcb89. 0310241231.7931 e8d6@posting.go ogle.com>...
              Hello!
              i am a newbie in oracle database. I have some question about SQL*PLUS
              >
              Currently, i have some table in an oracle database. When i open
              SQL*PLUS and type my query: "select * from employee". It display for
              me all the record in the database and then it also display how many
              record has been selected.
              but if i try to do this: "select * from customer" or select any table
              it still display all the record in that table but it didn't display
              the summary of how many record it has selected in that table. i would
              like to enable that feature in all the table that i have. i wonder if
              anyone have suggestion for me. thank you ahead for all the response
              and suggestion. it helps me a lot. so please send me your suggestion.
              all suggestion is appreciated. thank you very much. bye now.

              apps@DB01select * from t;

              A B
              --------- ---------
              19 20
              19 20

              apps@DB01set feedback on;
              apps@DB01/

              A B
              --------- ---------
              19 20
              19 20

              2 rows selected.

              apps@DB01set feedback off;
              apps@DB01/

              A B
              --------- ---------
              19 20
              19 20
              apps@DB01>

                Comment

                Previous template Next
                Working...