This worked very nicely because in this case I wanted to show all the distinct values. Thanks.

--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]


-------------- Original message from "Bhansali Vinod " <oracledba-ezmlmshield-x20271741.[Email address protected] --------------


> Run this before you run the query :
> alter session set NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss';
>

Oracle LazyDBA home page