Les enregistrements imbriqués (LDD)

CREATE OR REPLACE TYPE typBureau AS OBJECT (

centre char(2),

batiment char(1),

numero number(3)

);

/

CREATE TABLE tIntervenant (

pknom varchar2(20) PRIMARY KEY,

prenom varchar2(20) NOT NULL,

bureau typBureau

);