In order to get some useful answers, you will need to provide more information. The number of rows returned by a query depends on the data stored in the table(s), and the WHERE clause of your select statement. Please, paste the code of your select statement here (in discuss section), and explain what are the results you are getting and what are you trying to accomplish. If you can, add some example data also. The more specific your question, the better the chances to get an answer. If you are simply asking how to get the total rows selected printed via sqlplus, prior to the query, enter the command "set feedback 1". The default setting within sqlplus is typically 6. Just set feedback to the minimum number of rows you want Oracle to give you that feedback for. SQL*Plus has a wide array of formatting and i/o settings which you can control. While in SQL*Plus enter the command: show all this will show you all of the settings currently in place which you can modify to control output and formatting. I would suggest getting a SQL*Plus document for the version you are using to review all your options and to better understand their meanings and how to use them properly.

In order to get some useful answers, you will need to provide more information. The number of rows returned by a query depends on the data stored in the table(s), and the WHERE clause of your select statement. Please, paste the code of your select statement here (in discuss section), and explain what are the results you are getting and what are you trying to accomplish. If you can, add some example data also. The more specific your question, the better the chances to get an answer. If you are simply asking how to get the total rows selected printed via sqlplus, prior to the query, enter the command "set feedback 1". The default setting within sqlplus is typically 6. Just set feedback to the minimum number of rows you want Oracle to give you that feedback for. SQL*Plus has a wide array of formatting and i/o settings which you can control. While in SQL*Plus enter the command: show all this will show you all of the settings currently in place which you can modify to control output and formatting. I would suggest getting a SQL*Plus document for the version you are using to review all your options and to better understand their meanings and how to use them properly.