Home » SQL & PL/SQL » SQL & PL/SQL » Urgent: Inserting Rows form a Table on Other Database
Urgent: Inserting Rows form a Table on Other Database [message #9756] Wed, 03 December 2003 08:48 Go to next message
MaiVic
Messages: 1
Registered: December 2003
Junior Member
How could I insert a row into a table which the data came from a another database? Thanks.

Report message to a moderator

Re: Urgent: Inserting Rows form a Table on Other Database [message #9757 is a reply to message #9756] Wed, 03 December 2003 09:13 Go to previous messageGo to next message
sverch
Messages: 582
Registered: December 2000
Senior Member
YOU NEED DATABASE LINK

Report message to a moderator

Re: Urgent: Inserting Rows form a Table on Other Database [message #9778 is a reply to message #9756] Thu, 04 December 2003 02:53 Go to previous message
Prashanth
Messages: 41
Registered: September 1999
Member
Need have a link

Suppose that u have Table A in Local dB and Table B in remote B to which u have created a link as rem then
U can use this

insert into A values ( select ....... from B@rem);

Report message to a moderator

Previous Topic: order member function
Next Topic: How to get all dates between two dates in Oracle?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 16:53:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.