Yes - 2 major rules broken here:

1 - Never assume a column list. ie., never do SELECT * and never do INSERT *without* a column list

2 - Never assume a date format. (and for pete's sake, when specifying a format for a value, try to make the format match the value - no kidding that to_date('7/1/1998', 'DD-MON-YYYY')) is going to give an error - does 7/1/1998 look like a DD-MON-YYYY format? Sheesh)

- Chris