We have now created a new schema object in the DDL. Now to create a table we can type,

CREATE TABLE firstTable of firstType /

This will create the same table the only difference is that the DDL doesn’t create an object this time. The reason why you would create a schema object is so that you can create a number table that has the same attributes. Another reason why you’d use schema objects is the simplicity of inputting data into a table.

Let’s input data into our firstTable table using DML (i.e. Data Manipulation Language). We could simply insert data like this

INSERT INTO firstTable VALUES (1,’Kim’,’Tyson’);

How could we use schema objects for inputting data into a table? The answer is again very simple. We create a schema object and embedded the user defined schema object into the table.