Oracle Abstract Data Type

Oracle Abstract Data Type - Exercise

Create an ADT
Objective: Create an abstract data type.
Scoring

You will receive 5 points for this exercise.
The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

Background/overview
You have been asked to assist in creating a new employee table for your company that consists of the following items:

  salutation         char(3),
  first_name       char(40),
  mid_initial       char(1),
  last_name         char(40),

Instructions

In order to make the data type reusable in all Oracle tables, you have been asked to create an abstract data type called name_type that contains all of the name information. Provide the CREATE TYPE syntax and the corresponding CREATE TABLE syntax.