Thread: Temp Table
When I fetch a row, as in the following, how do I copy the row's data into a temporary table so that I can process it??
begin work;
Declare loop_set Cursor
for Select one, two, three, four, five, six, seven from loop_import
order by loop_id ;
fetch next From loop_set;
Declare loop_set Cursor
for Select one, two, three, four, five, six, seven from loop_import
order by loop_id ;
fetch next From loop_set;
Bob Pawley
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/19/07 11:39, Bob Pawley wrote: > When I fetch a row, as in the following, how do I copy the row's data into a temporary table so that I can process it?? > > begin work; > Declare loop_set Cursor > for Select one, two, three, four, five, six, seven from loop_import > order by loop_id ; > fetch next From loop_set; Wouldn't it be simpler to do: INSERT INTO some_temp SELECT field list FROM some_table; - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHGPp0S9HxQb37XmcRAlpUAKDTR/qG8VQxZJpt1IyqZp7l9Q+V0gCfSW54 ANpxcxz4AAOYddctMe4inJc= =1lk2 -----END PGP SIGNATURE-----