Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> select from another database

select from another database

From: mistvan <imanzuk_at_enternet.hu>
Date: 30 Jan 2003 10:40:34 -0800
Message-ID: <64c6ffb5.0301301040.735572eb@posting.google.com> 





Hi Folks!



I would like to know how can I select rows from another database and
insert them into the actual.


Eg. I'm logged in db1, and there is a database called db2. So, how
should I complete the insert statement below:
insert target_table (field1, field2)


select fld1, fld2


from scheme.sourcetable_at_db2



I think I don't know something. Please let me know.



Thanks in advance,


mistvan
Received on Thu Jan 30 2003 - 12:40:34 CST












Original text of this message













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