There is a standard function which is very useful for testing simple scenarios, but I can't for the life remember it! It's in one of the DBMS_* packages and works like this:
select * from table (dbms_something.function('Cheese','Chalk','Apples','Oranges'));
which returns four rows:
Cheese
Chalk
Apples
Oranges
Yes, I know it's possible to do it many others ways (and easily write my own), but there is something that already exists that does this, and I have used it in the past to quickly test things out; I just can't remember what it is!?