一、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.
六、事务