Q: multirow inserts

Hi,

I'd like to know whether it is possible returning the resultset (of constant values) without accessing a table.

E.g.:

select 'row1', 1, 13.6, 'AAAA'
union all
select 'row2', 7, 0.2, 'FFFF'
union all
select 'row3', 5, 7.3, 'xttU';

All values are constant so I see
no reason for necessity to access
any particular table. However the
statement above is invalid.

My intention is to insert data to my
table using the single (multirow) statement e.g.:

 insert into MyTable (col1, ... col2)
   <multirow select>;

Is there another way?

TIA --
Thank you for keeping >anti-spam< habit: not including my address in your reply. Received on Mon Jun 28 1999 - 05:17:51 CDT