Re: Move/insert data from MSSql to Oracle on Unix

not sure what you are doing
but whenever I have moved small amounts of data I have done something like this

selecct 'insert into mytable values '|| data || ' ; ' From mytable

"Jan Birk" <jb_at_invalid.domain.null> wrote in message news:4523a6e0$0$145$157c6196_at_dreader2.cybercity.dk...
>I have a MSSql and would like to move data between the MSSql and Oracle on
>Unix.
>
> How do I do that?
>
> I could use bcp on MSSql and Sqlldr on Unix, but I would prefer an insert
> or similar..... Is it possible?
>
> Thanks and best regards
>
> /Jan
Received on Wed Oct 04 2006 - 15:28:13 CDT