How do you display the number of rows selected if there are only 4 or 5 rows there?

5 pts.
Tags:
Oracle administration
Oracle queries
Oracle SQL
when i have 6 values for any column, in select statement i get display of 6 rows selected while if i have 5 values for one column i don't get display of 5 rows selected, how to get that display?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following