Explore BrainMass
Share

Solve the insert problem; ZIP CODE

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Make yourself a student by writing and executing an INSERT statement to insert a row into the STUDENT table with data about you. Use one of the zip codes you inserted in Exercise 1. Only insert values into the columns STUDENT_ID using the sequence you created in step 2, FIRST_NAME, LAST_NAME, ZIP, REGISTRATION_DATE (use a date that is five days after today), CREATED_BY, CREATED_DATE, MODIFIED_BY, and MODIFIED_DATE. Issue a COMMIT command afterwards.

© BrainMass Inc. brainmass.com March 21, 2019, 10:03 pm ad1c9bdddf
https://brainmass.com/computer-science/programming-languages/solving-insert-problem-zip-code-403157

Solution Preview

Hi,

You can do something like this...

INSERT INTO student
...

Solution Summary

This solution explains how to write and execute an INSERT statement for the given problem.

$2.19