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

Home -> Community -> Usenet -> c.d.o.server -> Re: Reference data manitenance tool?

Re: Reference data manitenance tool?

From: ChrisF <chris.freel_at_gmx.ch>
Date: 29 Dec 2005 00:05:22 -0800
Message-ID: <1135843522.354025.131820@g49g2000cwa.googlegroups.com>

  1. Start with the data in an Excel Spreadsheet. Three columns (RegionID, RegionName, MajorCity). Your "territory designer" can e-mail it back-and-forth or whatever you want.
  2. Use Word "Mail-merge" with the Excel spreadsheet as data source to generate a list: INSERT INTO MYTABLE (REGIONID, REGIONNAME, MAJORCITY) VALUES ({Col 1}, '{Col 2}', '{Col 3}'); Note the single quotes around the VARCHAR2 fields but not around the NUMBER field.
  3. Save the result in a plain text file with a ".sql" extension.
  4. Load it using your favourite SQL tool. Alternatively, copy / paste from Excel into a plain text file and do a few global edits / use "sed". Once you've done it once should take < 5 minutes.
Received on Thu Dec 29 2005 - 02:05:22 CST

Original text of this message

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