Union query: Add a constant value to a recordset

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

to get

All
East
North
South
West

What's the equivalent in Oracle SQL?

Thanks Received on Fri Dec 21 2007 - 04:14:05 CST