Example: Resumé

 

Suppose that you want to keep the application forms that are filled out by applicants to your company in a table, and that you are going to use functions to extract information from these forms.

Because these functions cannot be applied to regular character strings (because they are certainly not able to find the information they are supposed to return), you define a UDT to represent the filled forms:

     CREATE DISTINCT TYPE PERSONAL.APPLICATION_FORM AS CLOB(32K)

 

Parent topic:

Defining a UDT