create table director (
dirnumb number(3,0) constraint dirnumb_not_null not null
constraint dirnumb_pk primary key check (dirnumb > 0),
dirname varchar2(20) constraint dirname_not_null not null,
dirborn number(4,0) constraint dirborn_not_null not null,
dirdied number(4,0) );

prompt Created table director.;

insert into director values
(1, 'Allen, Woody', 1935, null);
insert into director values
(2, 'Hitchcock, Alfred', 1899, 1980);
insert into director values
(3, 'De Mille, Cecile B.', 1881, 1959);
insert into director values
(4, 'Kramer, Stanley', 1913, null);
insert into director values
(5, 'Kubrick, Stanely', 1928, null);
insert into director values
(6, 'Preminger, Otto', 1906, null);
insert into director values
(7, 'Ford, John', 1895, 1973);