I was just curious, would it be possible to generate a fake "table" of lets say, two rows from the table DUAL?
For example I could do this
SELECT '1' PRIM, 'CHILLY' COL2, 'ANIMAL' ANIMAL_TYPE
FROM DUAL;
Which would give me a row table of
PRIM COL2 ANIMAL_TYPE
---- ------ -----------
1 CHILLY ANIMAL
I was wondering how could i do something similar but have more then 1 row such as
PRIM COL2 ANIMAL_TYPE
---- ------ -----------
1 CHILLY ANIMAL
2 FUDGE ANIMAL
I know another way is i could write something like this
SELECT 'John Doe', '555-1212' FROM DUAL
UNION ALL
SELECT 'Peter Doe','555-2323' FROM DUAL
But was looking for something more "efficient" possibly to generate like lets say 10 rows
Thanks
Edited by: rodneyc8063 on Oct 2, 2011 6:12 PM