STEP 7 Make INSERT statements

Next, we convert the info in DATA.txt into INSERT statments

Replace '[' with :

INSERT INTO M70_SDR_TRANSIT(SDR_NUMBER_NUM,SDR_TEXT) VALUES(TO_CHAR(SYSTIMESTAMP,'HH24MISSFF6'),UPPER('

 and

Replace ']' with  :  '));

What we're going to do here is dump the data into M70.

To satisfy the minimum integrity requirements for the table we will,

• provide a temporary SDR-number by using a numeric timestamp

• drop the rest of the data-string into the 4000 character SDR text field

Note : the FAA descriptive text never exceeds 2000 chars, so theres always plenty of room to drop it all here.

Now our data file look should look somewhat like this :

Open