一、列的修改
准备工作:先创建一个表,并插入数据。
drop table member purge;
create table member(
mid number ,
name vachar2(50) default '无名氏');
insert into member (min,name)values(1,'李一');
insert into member (min,name)values(2,'章二');
insert into member (min,name)values(3,'王三');
commit;
-----------------------------------------------------------------------------------------------------
表中增加数据字段(增加列):
*语法:
Alter table 表名 add(字段名 字段类型 Default 默认值……);
#例子:
Alter table member Add(age number(3),photo vachar2(100) default 'nophoto.jpg');
-----------------------------------------------------------------------------------------------------