last entry in oracle

How do I get the last entry out of my log in Oracle?

I know in MySQL I can "LIMIT 1"

In Oracel I can do a MAX(LOG_ID) and get the last entry but only one field...

I need to do something like this, but this does not return all fields on that row...

SELECT *, max(LOG_ID) FROM LOG WHERE ITEM_ID = '3286'

Any Ideas?

Shouldnt it be something like:
SELECT * FROM LOG WHERE LOG_ID=max(LOG_ID);

or maybe just:
SELECT * FROM LOG ORDER BY LOG_ID DESC LIMIT 1;

Nice try on the first one...

and on the second LIMIT does not work in Oracle...

hmmmm

OK it can be done this way but there has to be a better way....

SELECT * FROM LOG WHERE ITEM_ID = '$ITEM_ID' AND LOG_ID = (SELECT max(LOG_ID) FROM LOG WHERE ITEM_ID = '$ITEM_ID');

Looks like a subquery is the way to go with Oracle then.