oracle 数据管理,oracle数据管理

表的定义和修改：

Oracle的数据类型，函数，事物及失误权限，表的约束

(表级定义，列级定义)

create table users(

ud number(4,0),

id number(3,-2),

nam char(32),

addrss varchar2(32),

birthday Date

);

rename users to users_;

rename users_ to users;

alter table users add(

add_col nvarchar2(12)

);

alter table users drop column add_col;

alter table users modify (

namvarchar2(64)

);

desc users;

drop table users;

//插入数据

insert intousers(ud,id,nam,addrss,birthday) values (1,156,'aaaa','aaa','12-9月-2012');

insert into users values(2,126,'bbbb','ccccc','11-9月-2012');

insert into users values(2,126,'bbbb','','11-9月-2012');

//查询数据

select * from users;

SELECT nam ,dump(nam) FROM users whereud=1;

//更新数据

update users set nam='Andy' where ud=1;

update users set  addrss='bbb' where ud=2;

update users set id=300;

update users set addrss='op' where addrssis  null;

//删除数据

delete users where ud=3;

序列：

/创建序列

create sequence seq

start with 1

increment by 1

minvalue 1

maxvalue 12000

cycle

nocache;

/使用seq

create table demo1(

idnumber primary key,

namevarchar2(32)

);

insert into demo1 values(seq.nextval,'andy');

select * from demo1;