Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Select max(id) not returning correct value

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US