Re: Table Error?

#1

<art (AT) unsu (DOT) com> wrote

Quote:

This is really weird. We do a count on a table and get 5,954,235
records. However, when we select the ata, there is only 1 record in
the table????

Suggestions anyone?

Offhand you are either accidently mixing table names and asking for fields
that don't exist, or have a bad 'where' porton (such as other person said
'where field = null' doesnt work. where field = 'null' might if you have
any where null is actually entered in there as the text!)

#2

art (AT) unsu (DOT) com wrote:

Quote:

This is really weird. We do a count on a table and get 5,954,235
records. However, when we select the ata, there is only 1 record in
the table????

Suggestions anyone?

select * from table where rownum=1;

--

Regards,
Frank van Bortel

#3

On Thu, 4 Jun 2009 17:46:05 -0700 (PDT), art (AT) unsu (DOT) com wrote:

Quote:

This is really weird. We do a count on a table and get 5,954,235
records. However, when we select the ata, there is only 1 record in
the table????

Suggestions anyone?

We do not speak Hindi.

--
Sybrand Bakker
Senior Oracle DBA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Table Error?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Table Error? - 06-05-2009 , 04:08 PM

Re: Table Error? - 06-07-2009 , 10:28 AM

Re: Table Error? - 06-07-2009 , 03:44 PM