Re: Select max(id) not returning correct value

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sat, 21 May 2005 14:38:35 +0800
Message-ID: <5e30486205052023382dda88e2@mail.gmail.com>

Tim's post describes the most logical path to go down, if you exhaust those options, try

select /*+ full(t) */ max(id) from mytable;

to rule out any index anomaly

hth
connor

On 5/20/05, Tim Gorman <tim_at_evdbt.com> wrote:
> Jacinta,

>=20
> What is the datatype of the ID column? Is it NUMBER or a text datatype? =
 If
> not number, then what are your NLS settings?
>=20
> Please do a DESCRIBE of the table/view in question and also SHOW PARAMETE=
R
> NLS?

>=20

> -Tim

>=20
>=20
--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
email: connor_mcdonald_at_yahoo.com
web: http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l

Received on Sat May 21 2005 - 02:43:21 CDT