thanks

what is the difference between

SELECT r.username, q.piece, q.sql_text
FROM V$SQLTEXT q, V$SESSION r
WHERE q.hash_value=r.sql_hash_value
and r.username='ICLICK'
order by r.sid, piece
/

and the previous SQL?

Cheers

btw the count(1) is to find repeated SQL, anyway i didnt write the query some consultant did

basically I want to know which SQL shows me the last SQL stmt issued by an user

[Edited by pando on 04-26-2001 at 12:26 PM]