Re: Union query: Add a constant value to a recordset

Chaihana Joe, 21.12.2007 11:14:
> Oracle noob here.
>
> I need to add the value 'All' to a single column resultset. In MS SQL
> Server I'd say
>
> SELECT Sub_Asset_Class
> FROM BIRT_Resp_Fin_Hierarchy_DIM
> UNION SELECT ' All'
> ORDER BY Sub_Asset_Class
>
> What's the equivalent in Oracle SQL?

SELECT Sub_Asset_Class
FROM BIRT_Resp_Fin_Hierarchy_DIM
UNION SELECT ' All' FROM DUAL
ORDER BY 1 Thomas Received on Fri Dec 21 2007 - 04:25:30 CST