Marten Lehmann wrote:
>> will return exactly one row of data with lets say 3 rows.
>
> Sorry, I was meaning columns.

I believe you want to do the following:

SELECT 'Bill', 'Gates', 'Redmond' FROM dual;