Re: From one DATABASE to another, not TABLE!

From: <sunrise828_at_my-deja.com>
Date: Mon, 22 Nov 1999 20:15:20 GMT
Message-ID: <81c88j$g9t$1@nnrp1.deja.com>

I'm not sure I totally understood, but since you mentioned "some" data I thought I'd make another suggestion. You could set up a database link and then you can use regular SQL to move the data as needed.

Insert into Table1
Select * from Table1_at_databaselink
where field1 = 'takeme';

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 22 1999 - 14:15:20 CST

This message: [ Message body ]
Next message: KRM: "Forms 4.5 - Counting Query Hits"
Previous message: sunrise828_at_my-deja.com: "Re: writing contents of oracle long variable to file"
In reply to: Billy Collins: "From one DATABASE to another, not TABLE!"
Next in thread: Shashank Tripathi: "Re: From one DATABASE to another, not TABLE!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US