Oracle常用相关知识集锦

一、select查询语句

 

二、DML

update TB set TB.a = '' where TB.b='';

insert into TB(a,b) values('','');

delete from TB where TB.a = '';

merge into TB using TB2 on (TB.a = TB2.a) when matched then

update ....

when not matched then

insert ....

三、DDL

Create table TB (

a number ,

b varchar2(20),

c number,

constraints TB_A_PK primary key(a),

constraints TB_C_FK foreign key(c) references TB2(a)

);

/

create table TB2  as select * from TB;

alter table TB add (d number);

alter table TB modify (b varchar(30);

 

drop table TB;

truncate table TB;

四、DCL

grant create view to user;

revoke create view from user;

commit;

rollback;

savepoint;

五、约束

1.not null

2.primary key

3.foreign key

4.check

5.

六、事务