1. Create or replace
create or replace view v1 (bookName, price) as select bookName, price from t_book2;
2. Alter
alter view v1 as select * from t_book2;
3. Insert into
insert into v1 values(null, '王者归来', '95', '教授', '2');
4. Update
update v1 set bookName='Java very good', price=200 where id=1;
5. Delete
delete from v1 where id=5;
6. Drop
drop view if exsits v4;