I have a practice table called KEYBOARD_LEARNING that I use as a log for my latest word per minute scores. I use this code so much I figured it's time to make a procedure or function or package. I'm honestly not sure which is best.
What remains static is emplid. All other columns are dynamic and will be different each time I use this insert to make a new row in my table
INSERT INTO keyboard_learning (emplid,wpm, date_completed,exercise,attempt,score_lvl)
VALUES ('000000000','67.66','14-AUG-2012','Keyhero.com','28','95.87% accuracy')
What is the best way to go about encapsulating this SQL? What would the code be?