--------------------------------------------------------------------------------
-- Types
--------------------------------------------------------------------------------

-- Sometimes, we want to define new datatypes.


-- We create a new type project_t:
CREATE TYPE project_t AS OBJECT 
(
  pno CHAR(5), 
  pname CHAR(20), 
  budgets DEC(7,2)
);



-- create a table of project with the type project_t
CREATE TABLE projects
(
  grade NUMBER,
  p project_t
);



-- This is the way to insert a tuple.
INSERT INTO projects VALUES 
(
  100,
  project_t('1234','database project',10)
);


-- Please try!