I would like to copy the contents of result set by
single command
e.g.,
select * from db1 where id 3;
result 1
result 2
now how to write this results into another db
without writing to a text file (outtext)...
when both source and destination has the same
structure
thanks
m.karthikeyan
insert into
...
select
...
-Original Message-
From: Dr M Karthikeyan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 9:51 AM
To: [EMAIL PROTECTED]
Subject: copy the result content from one db to another
I would like to copy the contents of result set by
single command
e.g
cc:
Subject: copy the result content from
one db to another
11/17/2003 10:51