Re: select distinct on computed column

In article <32D2C414.1A93_at_c-square.no.junk>, Alvin Sylvain <alvin_at_csquare. no.junk> writes
>I'm converting an application from Sybase to Oracle and I've run
>into a number of quandries.
>
>This one is performing a "distinct" select on a "computed" column.
>
>Eg:
>
> select distinct name || ' ' || type "nametype"
> from categorytable
>
>Sybase allowed this, altho Oracle seems to not.

What error are you getting? This is perfectly valid.

-- 
Jim Smith