Putting It All Together

You have now created a database table with the following format:

Name Nullable Type
C_NUMBER Not null NUMBER(38)
C_FIRST_NAME Yes CHAR(20)
C_LAST_NAME Yes CHAR(20)
C_BIRTHDAY Yes DATE
C_INFO Yes CHAR(10)

The contents of the customer table looks similar to the following:

C_NUMBER C_FIRST_NAME C_LAST_NAME C_BIRTHDAY C_INFO
1 Sam Snead 13-APR-52 New
2 John Future 01-JAN-01 New
3 Betty Falcon 01-FEB-90 New
4 Sally Snead 31-DEC-54 New
5 John Jones 29-FEB-60 New