Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Re: Reference data manitenance tool?
Re: Reference data manitenance tool?
- 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.
- 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.
- Save the result in a plain text file with a ".sql" extension.
- 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