Use the following script to insert data from your import table into your destination table
Question:
Use the following script to insert data from your import table into your destination table
INSERT INTO destination_table (Field1, Field2,... FieldN)
SELECT DISTINCT Field1, Field2,... FieldN
FROM import_table;
2. Complete step (1) for each destination table you forward engineered.Insert data into your parents tables before its children to avoid insert errors. Remember to include the foreign key columns in your INSERT and SELECT.
3. If you get a key violation error inserting into ADDRESS, go to your ADDRESS table and allow for nulls. (Click the ADDRESS table in the object browser, select Column, click Edit, turn Not Null toggle off). Then reattempt the insert.
4. If you get an error inserting dates into PURCHASE, replace your date columns in your SELECT then reattempt the insert.
DeliveryDate becomes .... to_date(DeliveryDate, 'DD-MM-YYYY')
Purchase Date becomes... to_date(PurchaseDate, 'DD-MM-YYYY')
5. Delete all your destination table data using DELETE FROM
6. Re-run your Import into ADDRESS scripts that uses IMPORT_EMPLOYEE.
Fundamentals of Financial Accounting
ISBN: 978-1259103292
4th Canadian edition
Authors: Fred Phillips, Robert Libby, Patricia Libby, Brandy Mackintosh