Re: sql dummies

Marten Lehmann wrote:

>> will return exactly one row of data with lets say 3 rows.

I believe you want to do the following:

SELECT 'Bill', 'Gates', 'Redmond' FROM dual; Received on Fri Mar 24 2006 - 16:16:23 CST