select distinct on computed column

From: Alvin Sylvain <alvin_at_c-square.no.junk>
Date: 1997/01/07
Message-ID: <32D2C414.1A93@c-square.no.junk>#1/1

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.

Is there a cheap easy way around this?

Thanks in advance for any pointers.

-- 
+-------------------------+------------------------------------------+


| Alvin Sylvain           | If government is the answer, it's time   |

| alvin_at_c-square.com      | to re-evaluate the question.             |

| PLEASE! NO JUNK E-MAIL! |   NO E-MAIL SOLICITATIONS!!  NO SPAM!!   |

+-------------------------+------------------------------------------+

Received on Tue Jan 07 1997 - 00:00:00 CST