RelationalDBDesign RelationalDBDesign 


Data Structures   «Prev  Next»

Oracle Abstract Data Type - Exercise

Create an ADT - Exercise

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.