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); |