Look in the documentation under the Oracle Application developers Guide.
Yes, you can create a function based index, which is a good idea.
Jim
"Nicolas Bronke" <bronke_at_gmx.net> wrote in message
news:9vpr0k$gvlrp$1_at_ID-121870.news.dfncis.de...
> > Yes, you can truncate the created_date, but that will force a full table
> > scan just to get the date component as of midnight.
>
> Is that true? I do not believe that. Where can I read about such.
>
> select * from tableA where trunc(created_date) = to_date('15/12/01',
> 'dd/mm/yy');
>
> regards
>
> Nicolas
>
>
Received on Wed Dec 19 2001 - 08:09:19 CST
