ViewsExample
insert into department values
(1, 'physics'),
(2, 'philosophy');
insert into all_student values
(10001, 'Abigail', '2016/09/01', NULL),
(10002, 'Barnabas', '2015/09/05', NULL),
(10003, 'Camille', '1990/09/03', '1994/06/04'),
(10004, 'Dagwood', '2018/09/04', NULL),
(10005, 'Exene', '1996/09/01', '2000/06/10');
|