Explore BrainMass

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

Solution Preview


You can do something like this...


Solution Summary

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