Purchase Solution

Solve the insert problem; ZIP CODE

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

Solution Preview

Hi,

You can do something like this...

INSERT INTO student
...

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Javscript Basics

Quiz on basics of javascript programming language.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

View More Free Quizzes
Related BrainMass Solutions

  • VB.Net Mortgage Problem

    It provides the program compressed in a zip file.

  • Mortgage calculator

    Make sure that there is no hard code values in the method. Insert comments in the program to document the program. I recommend a small paragraph per method. Remove hard values in all the methods.

  • VB Currency Conversion Program

    The program should only accept numbers in the range 1 to 10,000. Insert comments to document the program. Submit all files of your program in a zip file with clear instructions on how to execute and use the program.

  • Error Identification and Correction In SQL Statements

    59535 corrections to code. The other objective is to create a table called balance that includes the customer ID, last name, first name, and the customer's total balance (the sum of price for all orders).

  • Numerical solutions Euler & Runge Kutta

    540340 Numerical solutions Euler & Runge Kutta Need to solve and compare the results of the linear vs non linear pendulum problem.

  • Hierarchy Chart and Flowchart for a Database Application

    An application/database that includes the name, address, city, state, zip code, phone number, and blood type for the staff of a small service organization is discussed.

  • One Dimensional Dirichlet

    Implement V-cycle multigrid algorithm to solve the above problem. On each level of multigrid use Gauss-Seidel algorithm to solve the system of equations.

  • Java and C++ mortgage calculators

    Insert comments in the program to document the program. 2.Write the program as a procedural C++ program.

  • Using C Structure to store contact information

    The program should obtain the information from the structure, and output it as shown in attachment. Please see the attachment for complete information on the problem. The attached program includes a structure with a tag name info.

View More Related Solutions