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 Region
FROM RegionTable
UNION SELECT ' All'
ORDER BY Region

to get

All
East
North
South
West

What's the equivalent in Oracle SQL?

Thanks Received on Fri Dec 21 2007 - 04:17:40 CST