Re: 9i: Check- constraint Upper(Column)

Maxim Demenko schrieb am 02.04.2008 in <47F3D26E.5040606_at_gmail.com>:

> Just to comment a little bit - it is of course not an oracle bug, as
> Shakespeare already shown, the brackets are *not* optional. The whole
> syntax diagram for table index clause looks like
> [ schema. ]table [ t_alias ]
> (index_expr [ ASC | DESC ]
> [, index_expr [ ASC | DESC ] ]...)
> [ index_properties ]
> ( can be looked up
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5010.htm#i2062403
>
> ),
> so , what OP has done ( as in example above) - created function based
> index on (upper(trim(CLOGINNAME))) for table MySchema.MyTable with an
> *alias* trim, on this way the outer trim function will not do what OP
> expected.

Interesting. But where or how can I use this *alias* "trim"? It is not to be seen anywhere. So it sounds to me as *alias* is a nice word for a bug.
An error "missing brackets" would IMHO be more helpful.

> Best regards

Thank you for your explaination
> Maxim

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de