Union query: how to add a value to resultset

Oracle noob here.

I need to add a constant value to a single column recordset. In SQL Server this would be

SELECT RegionName
FROM RegionTable
UNION SELECT 'All'
ORDER BY RegionName

so I get

All
East
North
South
West

What's the Oracle equivalent?

Thanks Received on Fri Dec 21 2007 - 03:52:49 CST