New to Oracle

[informer30]

Hi All,

Iam new to Oracle....Iam using version 8.0.1, I have run a simple select statement and when the results return they only show half of the results or when I press f8 a different number of records appear.

Only when I do a select count I get a more consistent figure please can you advise how can I change this setting if available?

Many Thanks

 

[SantaMufasa]

Informer,

Can you please post the query in question? Also, what, specifically, do you mean by, "how can I change this setting if available"?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[informer30]

Mufasa,

when I do

select count()
from risk

I get the correct number of records, as compared to when I run

select *
from risk

I get changing number of records.....Is there a setting I have not ticked correctly?

Many Thanks

 

[SantaMufasa]

1) Your code was probably

select count(*) from risk;

...With a "(*)", right?

2) If you have no "WHERE" clause, then the number of rows should be identical...No "WHERE" clause means "RETURN ALL ROWS".

Can you please copy and paste (here) the actual running of your code, along with the resulting output?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[informer30]

Hi M,

I agree what you saying....but its not the result set or the query...it is a setting somewhere which is changing the number of records I am seeing.

Anyone any ideas?

Many Thanks

 

[Beilstwh]

There is no setting except using a where that will reduce the number of rows returned. Also, why are you using 8.0.1? Much newer versions are available

Bill
Lead Application Developer
New York State, USA

 

[informer30]

Hi B,

there is a setting which I have changed to show all results....

Before it only showing the number of records depending on the size of the results pane.

Setting in the 'tool/preference'

Cheers

 

[Beilstwh]

That is just pagination, it will still show all the records in the end. You must have pagesize and pause set. Hit enter and the next page will print.

Bill
Lead Application Developer
New York State, USA

 

[SantaMufasa]

Informer,

In case you are not familiar with the "PAUSE" setting to which Bill refers, you do the following at the SQL*Plus prompt:

SQL> set pause off

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[Beilstwh]

Sorry Dave, For a newbie I should have shown him the command. Thanks for the followup.

Bill
Lead Application Developer
New York State, USA