Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chetwest

    Copy Data from one DB Table to the same table in another DB

    In my last post..I meant to say DB-LINKS... About your LONGs. The first question would be: what type of data do they contain? In anycase, it is most likely going to require you to scan every record and compare. Hopefully, there is some sort of key value that you can use to specify which...
  2. chetwest

    Copy Data from one DB Table to the same table in another DB

    I would start out by creating a BD-LINK between the two databases. Then write selects that use MINUS or UNION to determine what is different or the same. You can take it a step further and use a PLSQL routine to loop through the results using a cursor and perform your inserts/updates/deletes...

Part and Inventory Search

Back
Top